File Sharing Problems

Fix Excel Opening as Read-Only in OneDrive Shared Folders

Aamir Naveed AkramAamir Naveed Akram Oct 12, 2026 871 views

Question details

Users need to resolve an issue where Excel workbooks in OneDrive shared folders open in read-only mode, preventing co-authoring.

How to Fix Excel Opening as Read-Only in OneDrive Shared Folders
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.
Before you start

Ensure that your device has an active internet connection and that all team members have been granted edit permissions for the shared OneDrive folder.

Solution 1Recommended

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.

1
Uninstall older Office versions

Go to Windows Settings > Apps > Installed apps, locate Microsoft Office 2016 (or your older version), and click 'Uninstall'.

2
Sign in to Microsoft 365

Navigate to office.com in your web browser and sign in with your active Microsoft 365 account credentials.

3
Install the latest apps

Click the 'Install apps' button on the Microsoft 365 dashboard to download and install the latest suite of Office applications.

4
Verify co-authoring

Open the shared file again from the OneDrive desktop folder to verify that AutoSave is on and co-authoring is active.

Upgrade Older Office Versions to Microsoft 365
Co-authoring enabled: You will see the profile avatars of other team members in the top right corner of the Excel ribbon when co-authoring is working correctly.
Free Microsoft Office alternative

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. 1. Download WPS Office: Download and install WPS Office from the official website on your computer.
  2. 2. Upload to WPS Cloud: Open the WPS Spreadsheet application, sign in, and upload your Excel file to WPS Cloud.
  3. 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.
Highly compatible with Microsoft Excel (.xlsx, .xls) formats to prevent formatting lossFree and lightweight, performing exceptionally well on older laptops and desktopsBuilt-in cloud collaboration features via WPS Cloud for real-time file sharingFamiliar spreadsheet interface that requires zero retraining for your team
microsoft office alternative - wps office

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.