Share your Excel 2016 workbook with others

In Excel, it's easier than ever to share your workbooks with others.

It takes just three steps to share a workbook.

Using a web browser, upload or create a new workbook on OneDrive, OneDrive for Business, or a SharePoint Online library.

  1. If you uploaded the file, click the filename to open it. The workbook will open in a new tab in your web browser.

  2. Click the Edit in Excel button. If you don't have this button, click Edit in Browser, and then click Edit in Excel after the page reloads.

  3. If you are prompted to choose a version of Excel, click Excel 2016.

  4. When the file opens in the Excel program, click Share in the upper-right.

  5. Type email addresses in the Invite people box, and separate each with a semicolon. Make sure to also select Can edit. When you’re done, click the Send button.

    Tip: Look at the bottom of the pane. The Get a sharing link lets you send the email invitation yourself. If you have Excel for Office 365 subscribers, you'll see the Send as attachment link. That lets you send a copy of the file as either an .xlsx, or .pdf file in an email message.

  6. If you clicked the Send button in the previous step, email messages will be sent to each person. The message will come from your email address. You will also receive a copy of the message, just so you know what it looks like.

If you clicked the Share button, people will receive an email message inviting them to open the file. They can click the link to open the workbook. A web browser will open, and the workbook will open in Excel Online.

Tip: If they're using the latest version of Excel, PowerPoint, or Word there's an easier way: They can click File > Open and select Shared with Me.

If you want people to work in the file at the same time, they can click Edit Workbook > Edit in Browser. If people want to use an Excel app to edit the file, they need to use a version of the Excel app that supports co-authoring. For more information on versions that support co-authoring, see Collaborate on Excel workbooks at the same time with co-authoring

It takes just three steps to share a workbook.

Using a web browser, upload or create a new workbook on OneDrive, OneDrive for Business, or a SharePoint Online library.

  1. If you uploaded the file, click the filename to open it. The workbook will open in a new tab in your web browser.

  2. Click the Edit in Excel button. If you don't have this button, click Edit in Browser, and then click Edit in Excel after the page reloads.

  3. Click Open Microsoft Excel.

  4. When the file opens in the Excel program, you may see a yellow bar which says the file is in Protected View. Click the Enable Editing button if that's the case.

  5. Click Share in the upper-right.

  6. Click Invite People. Then type email addresses, and separate each with a semicolon. Make sure to also select Can Edit. When you’re done, click the Share button.

    Tip: If you want to send the link yourself, click Share in the upper-right, and then click Copy Link > View and Edit.

  7. If you clicked the Share button in the previous step, email messages will be sent to each person. The message will come from your email address. You will also receive a copy of the message, just so you know what it looks like.

If you clicked the Share button, people will receive an email message inviting them to open the file. They can click the link to open the workbook. A web browser will open, and the workbook will open in Excel Online. If they want to use an Excel app to co-author, they can click Edit Workbook > Edit in Excel. However, they'll need a version of the Excel app that supports co-authoring. Excel for Android, Excel for iOS, Excel Mobile, and Excel 2016 for Office 365 subscribers are the versions that currently support co-authoring. If they don't have a supported version, they can click Edit Workbook > Edit in Browser to edit the file.

Tip: If they're using the latest version of Excel 2016 for Office 365 subscribers, there's an easier way: They can click File > Open... > Shared and select a file that has been shared by another person.

If you want people to work in the file at the same time, they can click Edit Workbook > Edit in Browser. If people want to use an Excel app to edit the file, they need to use a version of the Excel app that supports co-authoring. For more information on versions that support co-authoring, see Collaborate on Excel workbooks at the same time with co-authoring

See Also

Collaborate on Excel workbooks at the same time with co-authoring

Expand your skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×