What happened to shared workbooks?
If you're using the latest version of Excel and you're an Microsoft 365 subscriber, you may find that buttons related to the "Shared Workbook" feature are no longer on the Review tab. We've removed them because there's a much easier and better way to share workbooks, and that's with co-authoring.
You can still access the Shared Workbook buttons if you need them. For example, you may need to turn off the Shared Workbook feature, or you may be in the middle of using the feature. The quickest way to get these buttons back is to add them to your Quick Access Toolbar. The Quick Access Toolbar is the bar of small buttons at the top of the Excel window, to the right of the Save button.
Important: Be certain that you want to use these buttons before continuing. This feature has many limitations, and therefore we highly recommend co-authoring, which is the replacement for Shared Workbooks.
Add Shared Workbook buttons to the Quick Access Toolbar
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.
Then scroll through the list until you see Track Changes (Legacy). Select that item and click Add.
Scroll through the list until you see Protect Sharing (Legacy). Select that item and click Add.
Scroll through the list until you see Compare and Merge Workbooks. Select that item and click Add.
Click OK.
-
Now four new buttons will appear at the top of the Excel window. Each button looks like this:
You may encounter other articles that refer to these buttons being on the Review tab. But after doing the steps above, the buttons are available on the Quick Access Toolbar instead.