How to share excel workbook
How to share an Excel file
This section shows how to share an Excel workbook for multiple users by saving it to a local network location where other people can access it and make edits. You can keep track of those changes and accept or reject them.
With the workbook open, perform the following steps to share it:
- On the Review tab, in the Changes group, click the Share Workbook button.
- The Share Workbook dialog box will appear, and you select the Allow changes by more than one user at the same time. This also allows workbook merging check box on the Editing tab.
- Optionally, switch to the Advanced tab, select the desired settings for tracking changes, and click OK.
For example, you may want to have changes updated automatically every n number of minutes (all the other settings on the screenshot below are the default ones).
- Save you Excel file to a network location where other people can access it (the fastest way is by using the Ctrl + S shortcut).
If done correctly, the word [Shared] will appear to the right of the workbook's name as shown in the screenshot below:
Now, you and your colleagues can work on the same Excel file at the same time. You are free to accept or reject their changes, and after the desired changes have been incorporated, you can stop sharing the workbook. Further on in this tutorial, you will find the details on how to do all this.
- Workbooks that have tables or XML maps cannot be shared. So, be sure to convert your tables to ranges and remove the XML maps before sharing your Excel file.
- To be able to share a workbook, some privacy settings need to be disabled. Go to File > Excel Options > Trust Center, click the Trust Center Settings… button, and under the Privacy Options category, uncheck the Remove personal information from file properties on save box.