Fix a Shared XLS Workbook That Won't Open in Excel Online
Question details
The user needs to open an XLS workbook in Excel for the web when legacy workbook sharing prevents it from opening online.

- Product
- Microsoft Excel for the web and desktop Excel
- Device & OS
- not provided
- Scenario
- An XLS workbook stored in SharePoint Online or OneDrive needs to be opened and edited online.
- Observed behavior
- Excel for the web reports that the workbook cannot be opened because it is configured as a shared workbook.
Make sure you can open the workbook in desktop Excel and have permission to edit and upload it. Ask other editors to save their changes and close the file before you turn off legacy sharing.
Turn Off Legacy Sharing in Desktop Excel
Use desktop Excel to remove the legacy Shared Workbook setting that blocks the file from opening online.
From OneDrive or SharePoint, open the workbook in the desktop Excel app.
In Excel, select Review > Share Workbook, or select Share Workbook (Legacy) if that command is available.
On the Editing tab, clear “Allow changes by more than one user at the same time” and confirm the change.
Select File > Save, upload the updated file to OneDrive or SharePoint if needed, and open it again in Excel for the web.

Convert the Workbook for Modern Co-authoring
Use this method after disabling legacy sharing if multiple people need to edit the workbook through OneDrive or SharePoint.
Work With Excel Files in WPS Spreadsheets
WPS Office is a free, lightweight Office alternative with a familiar spreadsheet interface and support for common Excel formats, making it easy to move existing files into WPS. It does not change Excel Online's legacy sharing restrictions.

Frequently Asked Questions
Why won't my shared XLS workbook open in Excel for the web?
The workbook may have the legacy Shared Workbook feature enabled, which Excel for the web cannot open in that configuration. Open it in desktop Excel and turn off the setting under Review > Share Workbook.
What if I can't find Share Workbook on the Review tab?
In desktop Excel, the command may be hidden. In versions that support it, open File > Options > Quick Access Toolbar, choose All Commands, and add Share Workbook (Legacy).
Can multiple people edit the workbook after I turn off legacy sharing?
Yes. Save it as XLSX, store it on OneDrive or SharePoint Online, and use the Share button to give others edit access for modern co-authoring.
Does saving an XLS file as XLSX keep its macros?
No. XLSX does not preserve VBA macros. Check the workbook for macros and use an appropriate macro-enabled format if they need to be retained.




