How To Enable Share Workbook In Excel | Unhide Legacy Command

Enabling the legacy shared workbook feature in Excel requires adding the hidden “Share Workbook (Legacy)” command to the Quick Access Toolbar.

Microsoft deliberately hid the old Share Workbook button in current versions of Excel to steer users toward modern cloud co-authoring. The legacy feature still works well for teams on a local network, but the button won’t appear on your ribbon until you manually restore it. Here is the exact order to unhide and activate the Share Workbook command in Excel 2019, 2021, and Microsoft 365.

Where Did The Share Workbook Button Go?

Microsoft replaced the classic shared workbook model with co-authoring, which allows real-time editing on OneDrive and SharePoint. The old command is labeled Share Workbook (Legacy) and is excluded from the default ribbon in current Excel versions. Microsoft’s official support documentation confirms the feature is hidden by design but still available for users who need change tracking and merging on local network files.

How To Enable Share Workbook In Excel – The Exact Order

Enabling the legacy feature requires adding the hidden command to your Quick Access Toolbar, then configuring the workbook for shared access on a network drive.

1. Add the Command to the Quick Access Toolbar. Go to File > Options > Quick Access Toolbar. In the Choose commands from dropdown, select All Commands. Scroll down to Share Workbook (Legacy), select it, and click Add. Click OK to save. The new button now appears in your toolbar at the top of the Excel window. You can repeat this for Track Changes (Legacy), Protect Sharing (Legacy), and Compare and Merge Workbooks if your workflow needs them.
2. Open the Share Workbook Dialog. Click the Share Workbook (Legacy) button you just added. (You can also reach it via Review > Share Workbook on some layouts.)
3. Enable Multi-User Editing. On the Editing tab, check the box labeled Allow changes by more than one user at the same time. This activates the shared workbook environment.
4. Set Tracking and Update Options. Open the Advanced tab. Choose how long to keep change history, how often to update changes, and how to handle conflicting edits. The defaults work for most teams.
5. Save the Workbook to a Network Location. Click File > Save and choose a shared network path (for example, \\server_name\folder_name). Do not save to OneDrive or SharePoint—legacy sharing is not supported on cloud storage. After the save, the title bar displays “- Shared” next to the filename, confirming the feature is active.

Share Workbook Vs. Co-Authoring: Which One To Use

The right choice depends entirely on where your team saves files—legacy sharing for a local network, modern co-authoring for cloud storage. They are mutually exclusive for a given file.

Common Mistakes And How To Avoid Them

Share Workbook (Legacy) has several sharp edges that catch even experienced users. Watch for these pitfalls.

• Saving to OneDrive or SharePoint: The legacy feature disables the sharing checkbox when it detects a cloud sync location. Save the file to a plain network drive instead, or switch to co-authoring if your team uses cloud storage.
• Grayed-Out Checkbox: If the “Allow changes” checkbox is grayed out, the workbook is protected. Go to Review > Unprotect Workbook (or enter the password), then open the Sharing dialog again.
• Confusing The Buttons: The modern Share button (top-right corner of Excel) sends invites for cloud co-authoring. The Share Workbook (Legacy) button opens the old dialog. Make sure you added the correct command to your Quick Access Toolbar.
• Feature Conflicts: Shared workbooks block several Excel features including merged cells, tables, slicers, sparklines, array formulas, and hyperlinks. If your workbook uses these, you will need to strip them out before sharing or use co-authoring instead.
• Forgetting To Save After Enabling: The workbook is not shared until you save it after checking the box. The filename must show “- Shared” for the feature to be active.

The legacy Shared Workbook feature remains fully functional in current Excel versions when you know where to find it. For teams working on a local network, the old model works reliably once you have added the hidden command to your Quick Access Toolbar and saved the file to a shared drive. For everyone else, Microsoft’s modern co-authoring path delivers a smoother, real-time collaboration experience without the legacy limitations.