Fix Excel Opening as Read-Only in OneDrive Shared Folders
Question details
Users need to resolve an issue where Excel workbooks in OneDrive shared folders open in read-only mode, preventing co-authoring.

- Product
- Microsoft Excel, OneDrive
- Device & OS
- not provided
- Scenario
- Team members are trying to collaborate on an Excel workbook stored in a shared OneDrive folder.
- Observed behavior
- The Excel workbook opens as read-only for other users instead of allowing simultaneous co-authoring, usually locking the file for editing.
Ensure that your device has an active internet connection and that all team members have been granted edit permissions for the shared OneDrive folder.
Upgrade Older Office Versions to Microsoft 365
Older versions of Office, such as Office 2016, do not fully support real-time co-authoring in OneDrive, causing the file to lock for other users.
When a team member uses an older version of Excel (like Office 2016 or 2013), the application automatically locks the file upon opening. Upgrading all users to the latest Microsoft 365 version guarantees compatibility for real-time collaboration.
Go to Windows Settings > Apps > Installed apps, locate Microsoft Office 2016 (or your older version), and click 'Uninstall'.
Navigate to office.com in your web browser and sign in with your active Microsoft 365 account credentials.
Click the 'Install apps' button on the Microsoft 365 dashboard to download and install the latest suite of Office applications.
Open the shared file again from the OneDrive desktop folder to verify that AutoSave is on and co-authoring is active.

Remove Read-Only File and Protection Settings
The Excel file itself might be marked as read-only in its Windows properties, or have built-in workbook protection enabled.
Use WPS Office for Seamless Team Collaboration
If upgrading to Microsoft 365 subscriptions for the entire team is too expensive, WPS Office provides a free, lightweight, and highly compatible alternative that makes editing spreadsheets and team collaboration seamless.
- 1. Download WPS Office: Download and install WPS Office from the official website on your computer.
- 2. Upload to WPS Cloud: Open the WPS Spreadsheet application, sign in, and upload your Excel file to WPS Cloud.
- 3. Share and Collaborate: Click the 'Share' button in the top right corner to generate an edit link and share it with your team for real-time collaboration.

Frequently Asked Questions
Why does OneDrive say my Excel file is locked for editing?
This typically happens if someone has the file open in an older version of Office (like Office 2016 or 2013) that does not support real-time co-authoring. It can also occur if a user left the file open without an active network connection, causing the server to lock it.
Does Excel for the Web support co-authoring?
Yes, Excel for the Web supports real-time co-authoring by default. If desktop versions are causing read-only issues due to software limits, having all team members open the file via their web browser is a fast workaround.
How can I force Excel to allow multiple users to edit at the same time?
Ensure the file is saved in the modern .xlsx format (not the older .xls format), verify that the 'AutoSave' toggle is turned on in the top left corner of Excel, and ensure all users are accessing the file through a compatible Microsoft 365 desktop app or web browser.




