File Sharing Problems

Fix Excel Co-Authoring When a Workbook Opens Read-Only

Chanuka GeekiyanageChanuka Geekiyanage Nov 18, 2026 869 views

Question details

The user needs multiple people to edit an Excel workbook at the same time instead of opening it read-only.

Why Excel Co-Authoring Opens a Workbook as 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.
Before you start

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.

Solution 1Recommended

Store the Workbook in OneDrive or SharePoint

Use a supported cloud location instead of a network folder or email attachment.

1
Check the file location

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.

2
Save a cloud copy

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.

3
Share the cloud file

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.

Store the Workbook in OneDrive or SharePoint
Free Microsoft Office alternative

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.

Open and edit Microsoft Excel .xlsx and .xls filesUse a familiar spreadsheet interface with a minimal learning curveShare spreadsheet files through WPS cloud servicesWork with a lightweight office suite that offers free tools
microsoft office alternative - wps office

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.