SharePoint Document Issues

Fix Read-Only Excel File Locks in SharePoint Online

Camila MilosovichCamila Milosovich Nov 20, 2026 869 views

Question details

Prevent read-only users from blocking authorized editors from modifying a shared Excel file.

Fix Read-Only Excel File Locks in SharePoint Online
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.
Before you start

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.

Solution 1Recommended

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.

1
Verify edit access

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.

2
Check the editor's account

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.

3
Open with a supported version

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.

4
Capture the lock message

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 Excel co-authoring and editor sign-in
Free Microsoft Office alternative

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.

Open and edit Excel workbooks in WPS SpreadsheetCompatible with Microsoft Excel formats, including XLSXUse a familiar interface for spreadsheet tasksMove existing Office files into a lightweight office suite
microsoft office alternative - wps office

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.