Why is share workbook grayed out

This tool allows easy restoration of all corrupt Excel files including the charts, worksheet properties cell comments, and other important data. It is easy to use and compatible with both Windows as well as Mac operating systems. This supports the entire Excel version and the software also offers a free trial version.

Must try the above fixes to resolve the unshared workbook greyed out in Excel. If you have anything to share or any query to ask then follow us on Facebook , Twitter , Pinterest. She writes tech blogs and expertise on MS Office, Excel, and other tech subjects.

This is how you can share an Excel file with other users. I thank you for reading and hope to see you on our blog next week! How to share Excel file for multiple users and co-author a shared workbook by Svetlana Cheusheva updated on March 3, How to share Excel file for multiple users How to share Excel workbook and protect change tracking Limitations of shared Excel file How to edit Excel shared workbook Resolve conflicting changes in a shared workbook How to merge different copies of a shared workbook Remove users from Excel shared workbook How to unshare a workbook in Excel Share Excel workbook using OneDrive How to share an Excel file This section shows how to share an Excel workbook for multiple users by saving it to a local network location where other people can access it and make edits.

With the workbook open, perform the following steps to share it: On the Review tab, in the Changes group, click the Share Workbook button. The Share Workbook dialog box will appear, and you select the Allow changes by more than one user at the same time. This also allows workbook merging check box on the Editing tab. Optionally, switch to the Advanced tab, select the desired settings for tracking changes, and click OK.

If done correctly, the word [Shared] will appear to the right of the workbook's name as shown in the screenshot below: Now, you and your colleagues can work on the same Excel file at the same time. If Microsoft Excel refuses to share a certain workbook, most likely it's because of one of the following reasons: Workbooks that have tables or XML maps cannot be shared.

So, be sure to convert your tables to ranges and remove the XML maps before sharing your Excel file. To be able to share a workbook, some privacy settings need to be disabled.

If the workbook is already shared, and you want to protect sharing with a password, you must unshare the workbook first. You will be able to merge your changes at a later point. This action disconnects users only for the current session, but does not prevent them from reopening and editing the shared Excel file again.

Notes: Before clearing this box, make sure you are the only person listed under Who has this workbook open now. If there are other users, disconnect them first. If the box is uncheckable grayed out , most likely shared workbook protection is on. To unprotect the workbook, click OK to close the Share Workbook dialog box, and then click the Unprotect Shared Workbook button on the Review tab, in the Changes group.

Search Advanced search…. New posts. Search forums. Log in. Install the app. For a better experience, please enable JavaScript in your browser before proceeding.

You are using an out of date browser. It may not display this or other websites correctly. You should upgrade or use an alternative browser. Share Workbook is grayed out in the Tools menu. Thread starter Guest Start date Oct 20, Why is "Share Workbook" grayed out? What do I need to do differently to use that function? I'm using MS Office Pro Dave Peterson. Is that option always greyed out? JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.

You are using an out of date browser. It may not display this or other websites correctly. You should upgrade or use an alternative browser. Share Workbook - greyed out?? Thread starter tbablue Start date Jul 23, Joined Apr 29, Messages I cant see any macros in the workbook and protection is turned OFF. Any othe rideas? Excel Facts. Click here to reveal answer. Select a range of cells. The total appears in bottom right of Excel screen.

Right-click total to add Max, Min, Count, Average. Do you have the workbook opened as read-only?