The dataset showcases the Sales Analysis of the XYZ Store.
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.
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.
- Click Proofing.
- Choose New Group.
- Select New Group (Custom) and click Rename.
- Choose a name in the Display name field. Here, Share.
- Click OK.
- Select Share Workbook (Legacy).
- Choose Share (Custom).
- Click Add.
- Click OK.
This is the output.
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).
- 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.
What to Do If You’re Unable to Share the Excel Workbook
Steps:
- Go to the File tab.
- 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.
Download Practice Workbook
Related Articles
- How to Share Excel File for Multiple Users
- How to See Who Is in a Shared Excel File
<< Go Back to Share Workbook | Workbook in Excel | Learn Excel
Get FREE Advanced Excel Exercises with Solutions!
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