Why Is One SharePoint User Locked for Editing Excel Files?
Question details
The user needs to determine why one SharePoint user receives a “locked for editing” message in Excel while other team members can co-author the same workbook.

- Product
- Microsoft Excel and SharePoint Online
- Device & OS
- not provided
- Scenario
- A team co-authors a workbook stored in a SharePoint document library, but one user cannot open it for editing while others can.
- Observed behavior
- The affected user receives a “locked for editing” message, and if that user opens the file first, other users cannot edit it.
Confirm that the affected user can sign in to Microsoft 365 and has Edit permission on the SharePoint library. Have the user open the workbook in Excel for the web first to isolate desktop client issues.
Check the affected user's Excel version, sign-in, and workbook file format
Use this solution first because unsupported Excel versions or file formats are the most common causes of one-user SharePoint co-authoring failures.
SharePoint co-authoring requires a supported Excel client and a file saved as .xlsx, .xlsm, or .xlsb. Opening a local copy, email attachment, or snapshot can also make the workbook appear locked for one user.
On the affected user's computer, open Excel, select File > Account, confirm that the installed version is Microsoft 365, and ensure the user is signed in with the Microsoft 365 account that has SharePoint edit permission.
Open the SharePoint document library in a browser, select the workbook, and choose Open > Open in Browser. If editing works in Excel for the web, the issue is likely in the desktop client or OneDrive sync client.
In SharePoint, confirm the file extension is .xlsx, .xlsm, or .xlsb. Right-click the file and choose Open > Open in app instead of opening from a local folder, email attachment, or snapshot copy.

Update OneDrive and Office and open the workbook directly from SharePoint
Use this when the affected user's Excel client is supported but the workbook still opens locked, because outdated sync or desktop components can block co-authoring.
Test a new workbook and check file-specific sharing settings
Use this when the problem occurs only with a specific workbook, to determine whether file-specific settings are blocking the affected user.
Use WPS Office as a Free Alternative for Excel Workbook Editing
WPS Office is a free, lightweight Office alternative that opens and saves Excel .xlsx, .xlsm, and .xlsb files with a familiar ribbon interface. It helps teams avoid SharePoint client lock-ups by editing copies locally or in cloud storage with full format compatibility and seamless migration from Microsoft Excel.
- 1. Download and install WPS Office: Go to the official WPS Office website, download the free installer, and complete the installation.
- 2. Open your Excel workbook: Launch WPS Spreadsheets, select Open, and browse to the .xlsx file from your local drive or cloud storage.
- 3. Edit and save in Excel format: Make changes with familiar spreadsheet tools, then save the file as .xlsx to retain Microsoft Excel compatibility.

Frequently Asked Questions
Does Excel co-authoring work in WPS Office?
WPS Office can open and edit .xlsx files and supports cloud sharing through WPS Cloud, but SharePoint real-time co-authoring is controlled by Microsoft services. For SharePoint co-authoring, use Excel for the web or a supported Microsoft 365 desktop client.
Why does only one user get the locked for editing message in SharePoint?
Usually that user is on an unsupported Excel version, is not signed in with edit permission, is opening from a local or snapshot copy, or is using an outdated OneDrive or Office client.
What file formats support SharePoint co-authoring?
For Excel for Windows and Mac, use .xlsx, .xlsm, or .xlsb. Legacy .xls files and the Shared Workbook feature can prevent co-authoring.
How do I open a SharePoint workbook directly from Excel desktop?
In the SharePoint library, select the file, click Open > Open in app, and sign in if prompted. Do not open from a local synced copy or email attachment.
Can cached credentials cause a single user to be locked out of a SharePoint file?
Yes. Stale Microsoft 365 credentials can cause user-specific permission issues. Sign out of Excel and OneDrive, sign in again with the correct account, and then open the file directly from SharePoint.




