Fix Legacy Shared Workbook Access in Excel for iOS
Question details
The user needs to access and edit a shared Excel workbook on iOS while another person uses it in desktop Excel.

- 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.
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.
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.
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.
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.
Select File > Save As and save the workbook as an .xlsx file in OneDrive or SharePoint Online.
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.

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.

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.




