[Solved]: Share Workbook Not Showing in Excel (with Easy Steps)

Get FREE Advanced Excel Exercises with Solutions!

Share Workbook is a feature that enables you to share your file with multiple users. If you are using the latest version of Microsoft Excel you might not find the share workbook feature in the review tab. Microsoft has removed that option because there are much easier ways to share your workbook. One of the easiest ways is to use co-authoring feature. You don’t have to worry about that because you can still get the share workbook button if you need that. Check this link to learn more about co-authoring in excel. Today in this article I am going to share a step-by-step process solved share workbook not showing in excel.


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


2 Quick Steps to Solve Share Workbook Not Showing Problem in Excel

In this section, I am going to share with you 2 quick steps to solve the share workbook not showing the problem in excel.


Step 1: Open Excel Options Window to Get Quick Access Toolbar

As you can see opening the excel workbook I don’t have the share workbook option in the window. To solve share workbook not showing in excel follow the steps below-

Share Workbook Not Showing in Excel

  • Go to the “File” option from the home ribbon.
  • Select “Options” to continue.

Share Workbook Not Showing in Excel

  • A new window will appear named “Excel Options”.
  • Select “Quick Access Toolbar” from the left column.
  • From the drop-down list of “Choose commands from” select “All Commands”.

Share Workbook Not Showing in Excel

  • Scroll down to get the “Share Workbook (Legacy)”.
  • Chose the “Share Workbook (Legacy)” and click “Add”.

Read More: How to Share Excel File Online (2 Easy Methods)


Similar Readings


Step 2: Add Share Workbook Option to Home Ribbon in Excel

In the first step, we have successfully added the share workbook option from the quick access toolbar. Now follow the steps below to get it to the home ribbon.

  • After adding you will see the “Share Workbook (Legacy)” option is added in the “Customize Quick Access Toolbar”.
  • Press OK to get the desired output.

Share Workbook Not Showing in Excel

This way we have solved share workbook not showing in excel.

Read More: How to See Who Is in a Shared Excel File (With Quick Steps)


Things to Remember

  • You can also get the share workbook feature from the “Customize Ribbon” option. Check this link to learn more.

Conclusion

In this article, I have tried to cover the simple and quickest steps to solve the share workbook option not showing in excel. Take a tour of the practice workbook and download the file to practice by yourself. Hope you find it useful. Please inform us in the comment section about your experience. We, the Exceldemy team, are always responsive to your queries. Stay tuned and keep learning.


Related Articles

Wasim Akram

Wasim Akram

Hi! my name is Wasim Akram. I am a graduate in mechanical engineering from Ahsanullah University of Science & Technology. I am passionate about learning new things and writing articles. I write article about Microsoft Excel and it's my favourite thing to do.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo