What happened to shared workbooks?

If you're using the latest version of Excel 2016 for Office 365 subscribers, 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.

Access the Shared Workbook buttons

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.

  1. Click File > Options > Quick Access Toolbar.

  2. Open the list under Choose commands from and select All Commands.

  3. Scroll down that list until you see Share Workbook (Legacy). Select that item and click Add.

  4. Then scroll through the list until you see Track Changes (Legacy). Select that item and click Add.

  5. Scroll through the list until you see Protect Sharing (Legacy). Select that item and click Add.

  6. Scroll through the list until you see Compare and Merge Workbooks. Select that item and click Add.

  7. Click OK.

  8. Now four new buttons will appear at the top of the Excel window. Each button looks like this:

    • Share Workbook button: Share Workbook

    • Track Changes button: Track Changes button

    • Protect and Share button: Protect and Share Button

    • Compare and Merge Workbooks button: Compare and Merge button

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.

See Also

Collaborate with others on a workbook with co-authoring

Expand your skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×