File Cannot Open

Fix a Shared XLS Workbook That Won't Open in Excel Online

Chanuka GeekiyanageChanuka Geekiyanage Nov 22, 2026 868 views

Question details

The user needs to open an XLS workbook in Excel for the web when legacy workbook sharing prevents it from opening online.

Fix a Shared XLS Workbook That Won't Open in Excel 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.
Before you start

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.

Solution 1Recommended

Turn Off Legacy Sharing in Desktop Excel

Use desktop Excel to remove the legacy Shared Workbook setting that blocks the file from opening online.

1
Open the workbook

From OneDrive or SharePoint, open the workbook in the desktop Excel app.

2
Open sharing settings

In Excel, select Review > Share Workbook, or select Share Workbook (Legacy) if that command is available.

3
Disable legacy sharing

On the Editing tab, clear “Allow changes by more than one user at the same time” and confirm the change.

4
Save and reopen online

Select File > Save, upload the updated file to OneDrive or SharePoint if needed, and open it again in Excel for the web.

Turn Off Legacy Sharing in Desktop Excel
Changes to shared editing: Turning off legacy sharing removes its change history. Coordinate with other editors before disabling it.
Free Microsoft Office alternative

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.

Open and edit spreadsheets in a familiar interfaceCompatible with Microsoft Excel XLS and XLSX formatsFree, lightweight software for everyday spreadsheet workMove existing Office files into WPS without starting from scratch
microsoft office alternative - wps office

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.