Important: “Shared Workbooks” is an older feature that allows you to collaborate on a workbook with multiple people. This feature has many limitations, and has been replaced by co-authoring. Excel co-authoring is available in Microsoft 365 Apps Excel desktop client and Excel for the Web for Microsoft 365 subscribers.
Set up a shared workbook
- Click the Review tab.
- Click Share Workbook in the Changes group.
- On the Editing tab, click to select the Allow changes by more than one user at the same time. …
- In the Save As dialog box, save the shared workbook on a network location where other users can gain access to it.
If Microsoft Excel refuses to share a certain workbook, most likely it’s because of one of the following reasons:
- Workbooks that have tables or XML maps cannot be shared. …
- To be able to share a workbook, some privacy settings need to be disabled.
To share a workbook:
- Click the File tab to access Backstage view, then click Share.
- The Share pane will appear. …
- On the Share pane, if your document is saved to OneDrive, click the Share with People button.
- Excel will return to Normal view and open the Share panel on the right side of the window.
Can you see Excel edit history?
View the history worksheet. Click Review > Track Changes > Highlight Changes. Note that in newer versions of Excel, the Track Changes button has been hidden.
Can you see changes made in Excel?
See the changes that have been made to a workbook by going to the Review tab. Then click the Show Changes button. This will open up a task pane on the right side of the worksheet that has a running list. The list contains all of the changes that have been made in the workbook.
Click File > Options > Quick Access Toolbar. Open the list under Choose commands from and select All Commands. Scroll down that list until you see Share Workbook (Legacy). Select that item and click Add.
If you are trying to co-author, the “locked” error can occur if the file uses a feature that is not supported by co-authoring. Ask the person who has the file open to do one or more of the following. The first thing to try is to turn off the Shared Workbook feature.
Can multiple users work on the same Excel file at the same time?
You and your colleagues can open and work on the same Excel workbook. This is called co-authoring. When you co-author, you can see each other’s changes quickly—in a matter of seconds.
See who a file is shared with in OneDrive or SharePoint
- In your document library, select the file or folder.
- Above the list of files, select Share. The Send link window opens.
- If the item is currently shared with anyone, a Shared with list appears at the bottom of the Send link window.
How do I stop sharing an Excel file?
You can turn off sharing by following these steps:
- Display the Review tab of the ribbon.
- Click the Share Workbook tool, in the Changes group. Excel displays the Share Workbook dialog box.
- Clear the Allow Changes check box.
- Click on OK.
By sharing a workbook: A team can work simeltaneously on the same workbook. No multiple copies , all the data by everyone is in a single workbook. Can be used to collect information for surveys etc.