Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

If you're using the latest version of Excel and you're a 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

  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.

Add Shared Workbook buttons to the Quick Access Toolbar

  1. Click Excel > Preferences > Ribbon & Toolbar (under Authoring)

  2. Click Quick Access Toolbar.

  3. Under Choose commands from, click Review Tab.

  4. Select Share Workbook (Legacy) from the list, and click > to move the command to the Customize Quick Access Toolbar: list, and finally click Save.

See Also

Collaborate with others on a workbook with co-authoring

About the shared workbooks feature

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×