How to Upload Excel to One Drive

Before you tin share your Excel 2016 workbook, you must save a re-create of it in a folder on your OneDrive. The easiest way to do this is to first open up the workbook to share in Excel and click the Share push that appears on the correct side of the Ribbon.

Excel then opens a Share task pane in your worksheet with a Salvage to Deject push. Click the Save to Deject button to take Excel open the Relieve As screen in the Backstage View where yous tin save the workbook in a folder on your OneDrive.

Once you've saved the workbook on your OneDrive, Excel returns you to worksheet view with an updated Share task pane similar to the one shown here.

Inviting co-workers or clients to share an Excel workbook saved on your OneDrive in the Share task pane.

Y'all can see its options to share the workbook past following these steps:

1. Click the Invite People text box in the Share task pane and so begin typing the e-post address of the first person with whom you lot desire to share the workbook.

   As you type, Excel matches the letters with the names and email addresses entered in your Address Volume. When it finds possible matches, they are displayed in a drop-downwardly menu, and you can select the person's e-mail accost by clicking his or her name in the list. To find e-mail addresses in your Address list and add them to this text box, click the Search the Address Volume for Contacts button (to the immediate right of the Invite People listing box) and and then use the options in the Address Volume: Global Address List dialog box. To share the workbook with multiple people, type a semicolon (;) after each eastward-mail accost you add together to this text box.

   (Optional) Click the Tin Edit driblet-down button and select Can View option on the menu to prevent the people you lot invite from making whatever changes to the workbook you're sharing.

   By default, Excel 2016 allows the people with whom you share your workbooks to make editing changes to the workbook that are automatically saved on your OneDrive. If you want to restrict your recipients to reviewing the data without existence able to make changes, be certain to replace the Tin can Edit choice with Can View before sharing the workbook.

2. (Optional) Click the Include a Personal Message with the Invitation text box and blazon in any personal message that y'all want to incorporate as part of the email with the generic invitation to share the file.

   By default, Excel creates a generic invitation.

3. Click the Share push button.

   Equally soon as you click the Share push, Excel e-mails the invitation to share the workbook to each of the recipients entered in the Invite People text box. The plan also adds their e-mail addresses and the editing status of each recipient (Tin Edit or Can View) at the bottom of the Share task pane.

All the people with whom yous share a workbook receive an email message containing a hyperlink to the workbook on your OneDrive. When they follow this link, a copy of the workbook opens on a new page in their default web browser using the Excel Online Web app (if the web app is not uniform with the type of browser in apply on their device, the browser opens it with the web viewer). If you've given the user permission to edit the file, the web app contains an Edit Workbook push.

When users click this push button in Excel Online, they have a pick between selecting an Edit in Excel and Edit in Excel Online selection on its drib-downward carte. When they select Edit in Excel, the workbook is downloaded and opened in this version of Excel. When they select Edit in Excel Online, the browser opens the workbook in a new version of Excel Online, containing a File push button and Home, Insert, Data, Review, and View Ribbon tabs with a more limited gear up of command options than Excel 2016 that can be used in making any necessary changes (which are automatically saved to the workbook on the OneDrive).

You can likewise share a workbook previously saved on your OneDrive. Simply open the workbook in the OneDrive folder where information technology's saved and so click the Share button on the Ribbon.

Instead of sending electronic mail invitations to individual recipients with links to the workbooks y'all want to share on your OneDrive, y'all can create hyperlinks to them that y'all can then make bachelor to all the people who need online editing or review access.

To create a link to a workbook open up in Excel 2016 that's saved on your OneDrive, you click the Get a Sharing Link choice at the bottom of the Share task pane. When you click this link, an Edit Link and a View-only Link text option appears in the Share chore pane.

To create a view-just link that doesn't let online editing, simply click the Create a View-simply Link button Edit Link text box in the Share chore pane, and Excel displays a hyperlink in the button'due south text box with a Copy button at present appearing to its firsthand correct.

To create an edit link that enables online editing instead of a view-only link or in improver to it, yous click the Create an Edit Link button in the Share task pane. Excel then displays a hyperlink in this push'southward text box and a Re-create button now appears to its firsthand right.

After creating a view link or edit link for your workbook in the Share task pane, you can select the entire hyperlink by but clicking the Copy push button that appears to the immediate right of its text box. When you do this, Excel copies the long and complex hyperlink to the Office Clipboard (Ctrl+C). Afterwards copying information technology to the clipboard, you can insert it into a new electronic mail message (Ctrl+V) that you lot send to all the people with whom you lot desire to share the Excel workbook to which it refers.

Nearly This Commodity

This article is from the book:

• Excel 2016 For Dummies ,

About the book author:

Greg Harvey, PhD is the President of Mind Over Media. Greg wrote his first computer volume more than twenty years ago and since that fourth dimension, he has clustered a long list of bestselling titles including Excel All-In-1 For Dummies (all editions) and Excel Workbook For Dummies (all editions).

This commodity tin be found in the category:

• Excel ,

wilsongionly.blogspot.com

Source: https://www.dummies.com/article/technology/software/microsoft-products/excel/how-to-share-excel-2016-workbooks-via-onedrive-140038/

Share this post