Fix Read-Only Excel File Locks in SharePoint Online
Question details
Prevent read-only users from blocking authorized editors from modifying a shared Excel file.

- Product
- SharePoint Online and Microsoft Excel
- Device & OS
- not provided
- Scenario
- Many users open a SharePoint Online Excel file with read-only access while other users need to edit it.
- Observed behavior
- The file becomes locked when read-only users open it in Excel for the web or the desktop app, preventing authorized users from editing.
Confirm which users have edit permission and note whether they open the file in Excel for the web or the desktop app. Keep the file-in-use message available so you can identify any account named in it.
Check Excel co-authoring and editor sign-in
Use this approach to verify that authorized editors can open the shared file with a co-authoring-compatible Excel version and account.
Read-only users should not normally prevent users with edit permission from editing. Co-authoring requires supported file formats, compatible Excel versions, and appropriate permissions.
In the SharePoint document library, select the file, open the More options menu, and choose Manage access. Confirm that each intended editor has permission to edit.
Ask each editor to sign in to Excel with the Microsoft 365 account that has access to the file. In desktop Excel, check the signed-in account under File > Account.
From the SharePoint library, open the file in Excel for the web, or open it in a current desktop version of Excel that supports co-authoring. Confirm that the file uses a supported format such as .xlsx.
If editing is still blocked, record the username shown in the file-in-use message and take a screenshot. Share both with your Microsoft 365 administrator or support team for investigation.

Check whether the SharePoint library requires checkout
Use this check if the library's checkout settings may be preventing simultaneous editing.
Work with Excel Files in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and Microsoft Office format compatibility for an easier move between office suites. It does not resolve SharePoint Online locks or permissions.

Frequently Asked Questions
Should a read-only user lock an Excel file for editors?
Read-only access should not normally block authorized editors. If it does, check the editors' permissions, Excel versions, and Microsoft 365 sign-in, then capture the file-in-use message if the issue continues.
Where can I check an editor's SharePoint permissions?
In the SharePoint document library, select the workbook, open More options, and choose Manage access. Confirm that the user has edit permission.
Can a checkout requirement prevent co-authoring?
Yes. A library that requires files to be checked out can limit simultaneous editing. An administrator can review the setting under Library settings > Versioning settings.
What information should I collect if the file remains locked?
Record the username named in the file-in-use message and take a screenshot. Give these details to your Microsoft 365 administrator or support team.




