The Unshare Workbook Feature is Grayed Out in Excel – Quick solution

The dataset showcases the Sales Analysis of the XYZ Store.

excel unshare workbook greyed out

If you go to the Review tab on the Ribbon, you will see that the Unshare Workbook option is grayed out

Step 1 -Enabling the Share Workbook (Legacy) Option

  • Right-click any empty space on the Ribbon.
  • Choose Customize the Ribbon.

Enabling Share Workbook (Legacy) Option  if Unshare Workbook is greyed out in Excel

The Excel Options dialog box will open.

Note: You can also press ALT + F + T to open it. 

  • Click the drop-down icon beside Popular Commands.
  • Choose All Commands.

Editing Excel Options dialogue box if Unshare Workbook is greyed out in Excel

  • Click Proofing.
  • Choose New Group.

  • Select New Group (Custom) and click Rename.

  • Choose a name in the Display name field. Here, Share.
  • Click OK.

Renaming new group if Unshare Workbook is greyed out in Excel

  • Select Share Workbook (Legacy).
  • Choose Share (Custom).
  • Click Add.
  • Click OK.

This is the output.

Final output of step 1 if Unshare Workbook is greyed out in Excel

Read More: Setting Permissions for a Shared File in Excel


Step 2 – Enabling the Unshare Workbook Feature

  • Go to the Review tab.
  • In Share, choose Share Workbook (Legacy).

Enabling the Unshare Workbook Feature if Unshare Workbook is greyed out in Excel

  • In the Share Workbook dialog box, check the box under the Editing tab.
  • Click OK.

  • Click OK.

The Unshare Workbook option is no longer grayed.

Final output of method 1 if Unshare Workbook is greyed out in Excel


What to Do If You’re Unable to Share the Excel Workbook

Steps:

  • Go to the File tab.

What to Do If You’re Unable to Share Excel Workbook

  • Select Share.
  • Choose Save to Cloud.

  • Select OneDrive – Personal.
  • Click Save.

  • Select Share with People.

  • Enter the email id of the person you want to share the file with.
  • Click Send.

A confirmation will be displayed.

Final output of method 2 What to if you're Unable to Share Excel Workbook


Download Practice Workbook


Get FREE Advanced Excel Exercises with Solutions!
Zahid Hasan
Zahid Hasan

Zahid Hassan, BSc, Industrial and Production Engineering, Bangladesh University of Engineering and Technology, has worked with Exceldmy for 1.5 years. He has written 95+ articles for Exceldemy. He has worked as an Excel & VBA Content Developer. He also worked as a VBA Developer for the Template team. Currently, he is working as a Junior Software Developer for the Excel Add-in project. He is interested in Software Development, Python, VBA, VB.NET, and Data Science, expanding his expertise in... Read Full Bio

2 Comments
  1. Microsoft has recently changed their menus and dialogs to push you to the one drive option. Even the internal search function does not show this command as a result anymore. Thankfully this article helped me re-enable a a core feature we used on a shared workbook in the office! Lots of crumbs and props on adding the command in from the ribbon!

    Thank you!

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo