Permission & Access Issues

How to Fix Excel Read-Only File Prevents User From Saving

Jason Miller Oct 21, 2026 869 views

Question details

A user cannot save an Excel workbook because another user has opened it in read-only mode over a shared network.

How to Fix Excel Read-Only File Prevents Another User From Saving

Product: Microsoft Excel
Device & OS: not provided
Scenario: Multiple users are accessing the same Excel file on a shared network drive or local network folder.
Observed behavior: The first user who is actively editing the workbook receives an error and is prevented from saving their changes when a second user opens the same file as read-only.

Before you start

Ensure that you have administrative or write access to the shared folder, and ask all other users to temporarily close the Excel workbook before you attempt to modify permissions or network settings.

Solution 1Recommended

Map Network Drive with Different Credentials

Map the shared folder as a network drive using an account that explicitly has read/write permissions to resolve credential conflicts.

Often, Windows uses cached credentials that may only have read access to a shared folder. By mapping the drive with specific credentials, you ensure Excel recognizes your read/write permissions and prevents file-locking issues when others open the file.

Open File Explorer

Press Windows Key + E to open File Explorer and click on 'This PC' in the left-hand navigation pane.

Select Map Network Drive

Click on the three dots icon (or the 'Computer' tab at the top) and select 'Map network drive' from the drop-down menu.

Enter Folder Path

Choose an available drive letter from the list and enter the exact network path to the shared folder containing the Excel file.

Connect Using Different Credentials

Check the box labeled 'Connect using different credentials' and click 'Finish'. When prompted, enter the username and password of an account that has Modify or Read/Write access.

Map Network Drive with Different Credentials

Success: Once the drive is mapped, reopen the Excel file from this new drive letter. You should now be able to save changes without read-only restrictions.

Solution 2

Check Folder Permissions and Clear Stale Excel Processes

Verify that your user account has Modify permissions for the folder and ensure no background Excel processes are secretly locking the file.

Solution 3

Switch to Cloud Co-authoring

Migrate the file from a traditional network share to a modern cloud storage solution like SharePoint or OneDrive to enable simultaneous editing.

Seamless Collaboration

Use WPS Office for Real-Time Co-authoring

Avoid frustrating file locks and read-only network errors by using WPS Office. With its built-in cloud collaboration features, multiple users can edit the same spreadsheet simultaneously without saving conflicts.

1. Install WPS Office: Download and install WPS Office on your computer, then open your spreadsheet in WPS Spreadsheets.
2. Click Share: Click on the 'Share' button located in the top-right corner of the application interface.
3. Upload to Cloud: Follow the prompt to save and upload the spreadsheet to WPS Cloud to enable online collaboration.
4. Generate Link: Set the permission to 'Anyone with the link can edit' and share the generated link with your colleagues for simultaneous co-authoring.

Highly compatible with Microsoft Excel (.xlsx) formatsReal-time co-authoring via WPS Cloud prevents file locking errorsFree, lightweight, and fast office alternative for everyday tasksFamiliar user interface makes migration seamless

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel say a file is locked for editing even when no one is using it?

This typically occurs if Excel crashed previously and left a 'stale' process running in the background, or if the temporary lock file (usually starting with ~$) was not automatically deleted from the shared folder when the last user closed the document.

Can two users edit an Excel file at the same time on a local network drive?

On a traditional network drive (SMB share), Excel naturally locks the file for the first user to prevent data corruption. To edit simultaneously on a local drive, you must use the 'Legacy Shared Workbook' feature. However, it is highly recommended to migrate the file to cloud storage for modern co-authoring.

How do I force Excel to open a file in read/write mode?

Ensure your network drive is mapped with credentials that explicitly have write access. Also, right-click the file in File Explorer, select 'Properties', and ensure the 'Read-only' attribute box is unchecked. If the file is hosted on a server, an administrator may need to manually clear the open file session.

Document & File Issues