How To Share An Excel File

6 min read|Last Updated: February 5th, 2024|Categories: excel|
table of content

Excel 2016 and later versions provide a useful option to share your workbook easily and edit it at the same time by multiple users. This tutorial explains how to share an Excel workbook, step by step.

Use OneDrive to share Excel

OneDrive, which is Microsoft’s cloud product, lets you save your files and collaborate on them with others.

To add an OneDrive place to share your Excel worksheet go to the File tab, click on the Open, Save or Save as (all of these features has this option), click on the Add a place, select OneDrive or OneDrive for Business (OneDrive for Business is a particular paid version), and sign in with your Microsoft account. (according to video 1)

https://www.youtube.com/watch?v=iA6rNQ9w-jI&feature=youtu.be

Video 1- How to add a OneDrive place

To invite your colleague and share the file, click on the Share tab on top  left of the menu tab.

To invite your colleague and share the file, click on the Share tab from the left of the menu tab.
Picture 1- The Share tab

 

Then the Share pane will open on the left side of your worksheet. If you haven’t saved your file on the OneDrive yet, Excel asks you to save and copy your data to an online location by the “Save to cloud” button.

Excel asks you to save and copy your data to an online location by the “Save to cloud” button
Picture 2- The Share pane (save the file to the cloud)

 

By clicking on the Save to Cloud button, you can choose OneDrive to save the file. Select a Location to save the data, enter a name, and press Save.

How to save the Excel file to the OneDrive?
Picture 3- Save the Excel file to the OneDrive

 

If Windows security appears, enter your Microsoft email and password.