How to Fix Excel for the Web File Locked in Read-Only Mode
Question details
The user needs to troubleshoot a shared Excel file on the web that is locked in read-only mode when accessed.

- 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.
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.
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.
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.
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.
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.

Verify File Permissions and Check for Exclusive Locks
Use this method to ensure your account has the correct access rights and that the file isn't being locked by a desktop user.
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. Download and Install: Get WPS Office for free from the official website and install it on your device.
- 2. Open Your Spreadsheet: Launch WPS Spreadsheet and open your existing .xlsx files directly with perfect formatting retention.
- 3. Collaborate in Real-Time: Upload the file to WPS Cloud and use the 'Share' button to invite colleagues for seamless, simultaneous editing.

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.




