Because the traditional method of sharing is no longer supported by default, enabling it can be a bit complicated.
But if you’re dead-set on using this method, it can be done. Here’s how.
First, right-click on the Ribbon and select Customize Quick Access Toolbar.
In the resulting window, select Commands Not in the Ribbon from the Choose commands from dropdown:
Now you’ll need to find a few different commands to add to the Quick Access Toolbar. Scroll through the list and find the following:
- Compare and Merge Workbooks (Legacy)
- Protect Sharing (Legacy)
- Share Workbook (Legacy)
- Track Changes (Legacy)
Click OK, and you’ll see four new symbols in the Quick Access Toolbar:
To start the sharing and change-tracking progress, click the Track Changes button, and select Highlight Changes:
In the resulting window, Track changes while editing will be checked. Make sure that When and Who are set to All and Everyone:
Once you click OK, your spreadsheet will gain the [Shared] tag in the title bar.
Click the Share Workbook button and make sure that the Allow changes by more than one user at the same time checkbox is checked:
Finally, click the Protect Sharing button, and make sure that Sharing with tracked changes is turned on:
After all that, you can save and send your spreadsheet to your collaborators. Both sending the document via email and sharing it via OneDrive will work.
We recommend sharing via OneDrive, as it’s easier to keep track of who has copies of what.
If you share via OneDrive, your collaborators will need to download the spreadsheet and edit it in their Excel client.
To be safe, it’s a good idea to ask them to go through the same process to turn on tracked changes.
And when you get the spreadsheet back, you may need to click the Track Changes > Highlight Changes button again.