Office Compatibility Issues

Fix Legacy Shared Workbook Access in Excel for iOS

Huda QurayshiHuda Qurayshi Nov 22, 2026 868 views

Question details

The user needs to access and edit a shared Excel workbook on iOS while another person uses it in desktop Excel.

Fix Legacy Shared Workbook Access in Excel for iOS
Product
Microsoft Excel for iOS
Device & OS
iOS
Scenario
A workbook uses Excel's legacy Workbook Sharing feature and another user has it open in desktop Excel.
Observed behavior
Excel for iOS cannot open the legacy shared workbook while it is in use on desktop Excel.
Before you start

Ask all collaborators to save their changes and close the workbook before changing its sharing settings. Check that you have access to OneDrive or SharePoint Online and a desktop version of Excel that supports co-authoring.

Solution 1Recommended

Replace legacy Workbook Sharing with modern co-authoring

Use this method to let people edit the workbook simultaneously in Excel for iOS, Excel for the web, and a supported desktop version of Excel.

Excel for iOS does not support the legacy Workbook Sharing feature. Modern co-authoring requires a supported workbook format and a cloud location such as OneDrive or SharePoint Online.

1
Open the workbook in desktop Excel

After everyone else has closed the file, open it in desktop Excel and select Review > Share Workbook (Legacy). If the command is missing, add Share Workbook (Legacy) to the Quick Access Toolbar through Excel's customization settings.

2
Turn off legacy sharing

On the Editing tab, clear the option that allows multiple users to edit the workbook or use the old shared workbooks feature, depending on your Excel version. Select OK and save the workbook.

3
Save to a supported cloud location

Select File > Save As and save the workbook as an .xlsx file in OneDrive or SharePoint Online.

4
Share and co-author

Select Share in Excel, invite collaborators with permission to edit, and have them open the shared file in Excel for iOS, Excel for the web, or a desktop version of Excel that supports co-authoring.

Replace legacy Workbook Sharing with modern co-authoring
Legacy change history: Turning off legacy sharing removes the workbook's legacy change history. Review or preserve any history you need before disabling the feature.
Free Microsoft Office alternative

Edit Excel Workbooks with WPS Spreadsheets

WPS Office is a free, lightweight Office alternative with a familiar interface and support for Microsoft Excel formats, making it easy to move everyday spreadsheet work to WPS. It does not fix Excel for iOS's legacy sharing limitation.

Open and edit Microsoft Excel .xlsx filesUse familiar spreadsheet tools for everyday workbook editingWork with a free, lightweight Office suiteMove existing Office documents to a familiar interface
microsoft office alternative - wps office

Frequently Asked Questions

Why can't Excel for iOS open my shared workbook?

Excel for iOS does not support the legacy Workbook Sharing feature. To edit simultaneously across devices, turn off legacy sharing in desktop Excel and use modern co-authoring instead.

Where should I save the workbook for co-authoring?

In desktop Excel, use File > Save As to save an .xlsx copy to OneDrive or SharePoint Online. Then select Share and give collaborators editing permission.

What if I can't find Share Workbook (Legacy) in Excel?

Open Excel's Quick Access Toolbar customization settings and add the Share Workbook (Legacy) command. Use that command to access the legacy sharing settings.

Will turning off legacy sharing delete the change history?

Yes. Disabling legacy sharing removes the workbook's legacy change history, so review or preserve any history you need before turning it off.