[Fixed!] Unshare Workbook Greyed Out in Excel

In Excel, we often face the issue of Unshare Workbook option being greyed out. A number of Excel users have reported this as a frustrating and annoying problem. In this article, we will learn a quick and convenient solution to fix the issue of Unshare Workbook greyed out in Excel. So, let’s start this article and explore this solution with utmost concentration.


Download Practice Workbook


A Quick Solution When Unshare Workbook Is Greyed Out in Excel

In this section of the article, we will learn a quick and effective solution if Unshare Workbook is greyed out in Excel. Let’s say, we have the Sales Analysis of XYZ Store our dataset.

excel unshare workbook greyed out

If you go to the Review tab from Ribbon, you will see that the Unshare Workbook option is greyed out in the Protect group as shown in the following image. Using the Share Workbook (Legacy) feature, we can enable the Unshare Workbook option in Excel. Let’s follow the procedure discussed in the following section if Unshare Workbook is greyed out in Excel.


Step 01: Enabling Share Workbook (Legacy) Option

In the newer versions of Excel, the Share Workbook (Legacy) option is not available by default. So, we need to manually enable this feature.

  • Firstly, right-click on any empty space on the Ribbon.
  • Then, choose the Customize the Ribbon option.

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

As a result, the Excel Options dialogue box will open on your worksheet.

Note: You can also use the keyboard shortcut ALT + F + T to directly open the Excel Options dialogue box. 

  • Now, in the Excel Options dialogue box, click on the drop-down icon beside the Popular Commands field.
  • Afterward, choose the All Commands option from the drop-down.

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

  • After that, on the right side, click on any groups in the Review tab. In this case, we have selected the Proofing group.
  • Then, click on the New Group option.

  • Now, select the New Group (Custom) option and click on Rename.

  • Following that, choose your preferred name in the Display name field. Here, we used Share as the name for the newly created Group.
  • Then, click OK.

Renaming new group if Unshare Workbook is greyed out in Excel

  • Subsequently, on the left side, search for the Share Workbook (Legacy) option and select it after you have found it.
  • Now, choose the Share (Custom) group on the right side.
  • After that, click on the Add option.
  • Finally, click OK.

Consequently, the Share Workbook (Legacy) option will be available on your worksheet, as shown in the following picture.

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

Read More: [Solved!]: Excel Page Layout Being Greyed Out (4 Quick Fixes)


Step 02: Enabling the Unshare Workbook Feature

In this step, we will use the Share Workbook (Legacy) option to enable the Unshare Workbook feature.

  • Firstly, go to the Review tab from Ribbon.
  • After that, choose the Share Workbook (Legacy) option from the Share group.

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

  • Then, in the Share Workbook dialogue box, check the box in the marked field under the Editing tab.
  • Now, click OK.

  • Subsequently, the following window will pop-up, and click OK in the pop-up.

Consequently, you will see that the Unshare Workbook option is no longer greyed out as demonstrated in the following image.

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

Read More: [Solved]: If Macro Settings Is Greyed out in Excel


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

While working in Excel, sometimes we can’t share our Excel workbooks with others. In this section of the article, we will learn how we can properly share an Excel workbook. Let’s use the steps outlined in the following section to do this.

Steps:

  • Firstly, go to the File tab from Ribbon.

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

  • After that, select the Share tab.
  • Then, choose the Save to Cloud option on the right side.

  • Following that, select the OneDrive – Personal option as marked in the following picture.
  • Now, click on the Save option.

  • Afterward, select the Share with People option.

  • Then, type in the email id of the person that you want to share the file with.
  • Following that, click on Send.

As a result, Excel will give a confirmation that the link of the shared file is successfully sent as shown in the image below

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

Read More: [Fixed!] Merge Cells Button Is Greyed Out in Excel


Conclusion

Finally, we have come to the very end of the article. I sincerely hope that this article was able to guide you to fix the issue of Unshare Workbook greyed out in Excel. Please feel free to leave a comment if you have any queries or recommendations for improving the article’s quality. To learn more about Excel, you can visit our website, ExcelDemy. Happy learning!


Tags:

Zahid

Zahid

Hello and welcome! Thank you for visiting my profile. I am currently employed as an Excel & VBA Content Creator at ExcelDemy. My most recent academic qualification is a BSc (Eng) from the Bangladesh University of Engineering and Technology. Industrial and Production Engineering was my major. I constantly attempt to think creatively and find a simple answer.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo