Fix SharePoint Documents Opening Read-Only for One User in Excel for the Web
Question details
A user needs to edit SharePoint documents in Excel for the web, but they open as read-only for that account.
- Product
- SharePoint and Excel for the web
- Device & OS
- not provided
- Scenario
- One user can edit documents in desktop Office applications but needs to edit them in a browser.
- Observed behavior
- Multiple files open as read-only for the affected user across different browsers, while desktop editing is available.
Confirm that the affected user is signed in to the correct Microsoft 365 account and that the issue occurs with multiple files and browsers. Ask a SharePoint site administrator to review the user's access before changing permissions.
Recheck and Restore the User's SharePoint Edit Access
Use this approach when only one account is affected and its site access may be inconsistent.
As a site administrator, open the SharePoint site, select Settings > Site permissions, and check how the affected user has been granted access. Also use a file's Manage access option to check for file-specific restrictions.
Check whether the user receives Edit permission through a site group, direct access, or a sharing link. If access is inherited or managed by a group, identify the administrator who can change that membership.
After confirming how access is granted, remove the affected user's site access through the appropriate permission or group controls, then add the user back with Edit permission. Avoid changing permissions for other users.
Have the user sign out and back in to the correct Microsoft 365 account, reopen a SharePoint workbook in Excel for the web, and try editing a cell.
Check File Restrictions and Browser Editing Policies
Use this check to rule out document-level restrictions or organization policies that could prevent browser editing.
Request a Microsoft 365 Account Investigation
Use this option if permissions and file restrictions do not explain why all documents remain read-only in the browser.
Edit Compatible Spreadsheets with WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for working with Office files. It can make migration easier, although it does not fix SharePoint permissions or Microsoft 365 account issues.

Frequently Asked Questions
Why can I edit a SharePoint workbook in desktop Excel but not in the browser?
The browser may be using a different signed-in account, or an account, file, or organization policy may affect web editing. Check the account in Microsoft 365, then ask an administrator to review the file's Manage access settings and applicable policies.
Where can an administrator check my SharePoint permissions?
On the SharePoint site, open Settings > Site permissions to review site access. For a specific document, select the file and open Manage access to check its permissions.
Does being able to create or delete files mean I can edit workbook contents?
Not necessarily. File-specific permissions, protection, checkout status, or browser access policies can still affect editing. Ask an administrator to check the workbook's Manage access settings and document status.
What should I do if every workbook is still read-only in Excel for the web?
If the issue persists across files and browsers after access is checked, ask your Microsoft 365 administrator to create a request through Help & support in the Microsoft 365 admin center.




