You cannot select the legacy Shared Workbook feature because it is greyed out in your Excel menu. This happens because Microsoft has replaced the old feature with modern co-authoring. Your file is likely stored in a cloud location like OneDrive or SharePoint, which automatically enables the new system. This article explains why the option is unavailable and provides steps to use the current collaboration tools.
Key Takeaways: Moving from Shared Workbook to Co-Authoring
- Review > Share Workbook (Legacy): This menu item is permanently disabled for files saved to OneDrive, SharePoint, or the newer .xlsx format.
- File > Save As > OneDrive: Saving your workbook to a cloud service is the primary requirement for enabling real-time co-authoring.
- Share button in the top-right corner: Use this to invite collaborators and see who is editing the file live, replacing the old shared workbook tracking.
Why the Shared Workbook Feature is No Longer Available
The Shared Workbook command under the Review tab is a legacy feature from older Excel versions. It allowed multiple users to edit a single file stored on a network drive, but it had significant limitations like frequent conflicts and data loss. Microsoft has deprecated this feature in favor of co-authoring, which provides real-time collaboration.
Co-authoring requires the workbook to be saved in the modern .xlsx, .xlsm, or .xlsb file format and stored on a cloud platform that supports the Microsoft 365 collaboration protocol. The primary platforms are OneDrive, OneDrive for Business, and SharePoint Online. When you save a file to one of these locations, Excel automatically disables the old Shared Workbook menu and enables the new co-authoring infrastructure. This is why the option appears greyed out and unavailable for selection.
Technical Requirements for Co-Authoring
Your Excel application must be a Microsoft 365 subscription version or Excel 2021, 2019, or 2016. Excel for the web always supports co-authoring. All editors need permission to access the file and a version of Excel that supports the feature. The workbook cannot contain certain legacy elements like Excel 4.0 macros or specific types of data validation that block simultaneous editing.
Steps to Enable and Use Modern Co-Authoring
Follow these steps to collaborate using the current co-authoring system instead of the old shared workbook.
- Save your workbook to a cloud service
Open your file in Excel. Go to File > Save As. Choose your OneDrive, OneDrive for Business, or a SharePoint Online site as the save location. Click Save. This step is mandatory and enables the co-authoring backend. - Share the file with collaborators
Click the Share button in the top-right corner of the Excel window. In the Send Link pane, enter the email addresses of the people you want to edit with. Use the dropdown menu to set their permission to “Can edit.” Click Send. - Identify active co-authors
Once you have shared the file, you will see profile pictures or initials of other editors in the top-right corner, near the Share button. Click on these icons to see a list of everyone currently working in the workbook. - Edit simultaneously and see changes
Each person can open the file from the shared link and edit cells. Changes from others will appear automatically, often within a few seconds. A colored border and cell cursor will indicate where another person is editing.
If You Must Use the Legacy Feature
If you have a specific workflow that requires the old Shared Workbook tool, you must bypass the cloud requirement. Save a copy of your file locally on your computer’s hard drive or a traditional network share drive using File > Save As. The workbook must also be in the older .xls format for Excel 97-2003. After saving locally in the old format, the Review > Share Workbook option may become available, but its use is not recommended for team collaboration.
Common Co-Authoring Issues and Limitations
“AutoSave is turned off” message appears
Co-authoring requires AutoSave to be on. If you see this message, check your file location. If the file is not on a supported cloud service, move it there. Also, ensure the toggle switch for AutoSave in the top-left corner of the Excel window is turned on (it should be blue).
Cannot edit a specific cell or sheet
Certain actions lock a portion of the workbook for a single editor. These include creating a table, filtering a range, inserting or deleting worksheets, and editing a cell that is part of an array formula. Wait for the person performing that action to finish, or communicate with them via the comments feature to coordinate edits.
Changes from others are not showing up
First, check your internet connection. Then, manually refresh the view by pressing Ctrl+F5 or by clicking File > Info and looking at the version history. If the problem continues, close and reopen the workbook from the cloud location to re-establish the connection to the co-authoring service.
Legacy Shared Workbook vs. Modern Co-Authoring
| Item | Legacy Shared Workbook | Modern Co-Authoring |
|---|---|---|
| Primary storage location | Local network file share | OneDrive or SharePoint Online |
| Real-time updates | No, users must save and refresh | Yes, changes appear live |
| Conflict resolution | Manual, via a conflict history sheet | Automatic, with last edit winning or merge |
| Feature availability | Greyed out for cloud files | Automatically enabled for cloud files |
| User presence indicator | None | Shows avatars in top-right corner |
You can now collaborate on Excel files using the modern co-authoring system. Save your workbook to OneDrive and use the Share button to invite team members. For advanced control, use the Review > Comments pane to discuss changes directly within cells. Remember that protecting a worksheet with a password will prevent co-authoring on that sheet, so apply sheet protection only after collaborative editing is complete.