Fix Excel Co-Authoring When a Workbook Opens Read-Only
Question details
The user needs multiple people to edit an Excel workbook at the same time instead of opening it read-only.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Several people are trying to co-author the same workbook.
- Observed behavior
- Only the first person can edit; other co-authors receive read-only access.
Ask the workbook owner where the file is stored and how it was shared. Have co-authors sign in to their Microsoft accounts and check that they are using a version of Excel that supports co-authoring.
Store the Workbook in OneDrive or SharePoint
Use a supported cloud location instead of a network folder or email attachment.
In Excel, select File > Info and check the workbook's location. A file opened from an email attachment or network folder is not using the supported cloud co-authoring workflow.
Select File > Save As and save a copy to OneDrive or a SharePoint document library. Use the .xlsx format if the workbook is in an older Excel format.
Open the saved cloud copy, select Share, and send a link that allows editing. Ask everyone to open that same link rather than a local or emailed copy.

Give Every Co-Author Edit Access
Check permissions when the workbook is already in OneDrive or SharePoint but some people can only view it.
Remove Locks and Check Legacy Sharing
Use this solution if the cloud location and permissions are correct but the workbook still opens read-only.
Work With Excel Files in WPS Spreadsheets
WPS Office is a free, lightweight alternative with a familiar interface for opening and editing spreadsheets. Its Excel format support helps you move existing files into WPS; it does not change Excel's co-authoring permissions or resolve Microsoft cloud locks.

Frequently Asked Questions
Can people co-author an Excel file stored on a network drive?
For modern Excel co-authoring, save the workbook to OneDrive or SharePoint and share a link with edit access. A network-folder copy does not use the supported cloud co-authoring workflow.
How do I change a shared workbook from view-only to editable?
In OneDrive or SharePoint, select the file and open Manage access to grant edit permission. Alternatively, select Share and create a link with Can edit enabled.
Why is my SharePoint workbook still locked?
The file may be checked out or open in another application. Check its status in the SharePoint document library, have the person who checked it out check it in, and close any other copies before reopening it.
Does the legacy Shared Workbook feature support modern co-authoring?
No. Check Review > Share Workbook (Legacy), if that command is available, and turn off legacy sharing before using modern co-authoring. Review Excel's warning because disabling it can remove change history.
Can co-authors edit the workbook in a browser?
Yes. Co-authors with edit permission can open the OneDrive or SharePoint link and choose Edit in browser to work in Excel for the web.




