Permission & Access Issues

How to Fix Excel for the Web File Locked in Read-Only Mode

Adam DavisAdam Davis Nov 10, 2026 869 views

Question details

The user needs to troubleshoot a shared Excel file on the web that is locked in read-only mode when accessed.

How to Fix Excel for the Web File Locked in Read-Only Mode
Product
Excel for the Web
Device & OS
not provided
Scenario
Attempting to edit a shared Excel workbook online that another user has already opened.
Observed behavior
The file opens in read-only mode, preventing the user from making edits, despite other users having normal editing access.
Before you start

Verify with your colleagues whether someone currently has the file open in their desktop Excel application, as this is the most common cause of file locks.

Solution 1Recommended

Clear Browser Cache and Test in a Private Window

Use this solution to eliminate authentication glitches or browser extension conflicts that might be failing to validate your edit permissions.

Cached data or active browser extensions can sometimes interfere with Microsoft 365 authentication tokens, incorrectly flagging your session as having view-only permissions.

1
Clear browser cache and cookies

In your browser (e.g., Microsoft Edge), click the three dots in the upper-right corner and navigate to Settings > Privacy, search, and services. Click 'Choose what to clear', select Cached images and files as well as Cookies, and clear the data.

2
Open an InPrivate or Incognito window

Press Ctrl+Shift+N on Windows or Command+Shift+N on Mac. In this fresh private session, log in to Microsoft 365 and attempt to open the Excel file for the web.

3
Refresh your Microsoft 365 session

Sign completely out of your Microsoft 365 account using the profile icon in the top right corner, then sign back in to refresh your access credentials.

Clear Browser Cache and Test in a Private Window
Session Refreshed: If a stale session was causing the issue, clearing the cache and logging back in will restore your proper editing rights.
Free Microsoft Office alternative

Try WPS Office for Seamless Co-Editing

Tired of dealing with locked files and permission errors? WPS Office offers a free, lightweight alternative with robust cloud collaboration, seamless Microsoft Excel format compatibility, and a highly familiar user interface.

  1. 1. Download and Install: Get WPS Office for free from the official website and install it on your device.
  2. 2. Open Your Spreadsheet: Launch WPS Spreadsheet and open your existing .xlsx files directly with perfect formatting retention.
  3. 3. Collaborate in Real-Time: Upload the file to WPS Cloud and use the 'Share' button to invite colleagues for seamless, simultaneous editing.
Real-time co-authoring without exclusive lock issuesFully compatible with Microsoft Excel formats (.xlsx, .xls, .csv)Free and lightweight alternative to Microsoft 365Familiar spreadsheet interface with zero learning curve
microsoft office alternative - wps office

Frequently Asked Questions

Why does my shared Excel file say read-only when I open it?

This usually happens if another user has the file open in the desktop version of Excel with exclusive access, or if your permission level was set to 'View' instead of 'Edit' in SharePoint or OneDrive.

Can clearing my browser cache really fix read-only errors in Excel for the Web?

Yes, outdated cache or corrupted cookies can cause authentication conflicts, making Excel for the Web fail to recognize your edit permissions. Clearing them forces a fresh authentication check.

How do I force an Excel file to unlock from read-only mode?

You cannot force an unlock if another user has an exclusive lock on the file. You must ask the user to close the file or switch to co-authoring mode. If it is a system glitch, signing out of Microsoft 365 and clearing your cache can clear phantom sessions.