'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix Excel File Locked for Editing in SharePoint or Teams
Question details
Users are unable to edit an Excel file synchronized from SharePoint or Teams because it opens in read-only mode or displays a locked for editing error on the desktop app.
- Product
- Microsoft Excel, SharePoint, Teams
- Device & OS
- not provided
- Scenario
- Opening a shared Excel file via the desktop application for co-authoring.
- Observed behavior
- The file works online but appears locked or read-only on specific laptops until the user explicitly selects Edit Workbook or resolves account sync conflicts.
Ensure your internet connection is stable and verify that the Excel file is not currently opened by a colleague using an unsupported, older version of Microsoft Office.
Sign In with the Correct Licensed Account
Account conflicts often cause permission issues. Ensure you are using the work account associated with your Teams or SharePoint access.
Excel files hosted on SharePoint or Teams require valid Microsoft 365 licenses and appropriate access permissions. If you are signed into Excel with a personal account or an unrelated work account, the desktop app will restrict editing and lock the file.
Launch Microsoft Excel, click on 'File' in the top-left corner, and select 'Account' from the bottom of the left sidebar.
Under the 'User Information' section, click 'Sign Out' for any personal or incorrect Microsoft accounts currently logged in.
Click 'Sign In' and enter the credentials for the licensed work or school account that has explicit permission to access the SharePoint or Teams file.
Update Excel and Check OneDrive Sync
Outdated software or pending OneDrive synchronizations can prevent co-authoring and cause file locks.
Repair Your Microsoft 365 Installation
If Excel continues to lock files incorrectly despite correct permissions, the Office installation may be corrupted.
Try WPS Office for Seamless Spreadsheet Editing
If Microsoft Excel continues to restrict your access with 'locked for editing' errors, consider using WPS Office. It is a lightweight, highly compatible alternative that allows you to easily edit and manage your spreadsheets without complex account conflicts.
- 1. Download WPS Office: Visit the official WPS website and download the free installation package.
- 2. Install the Software: Run the installer and follow the on-screen instructions to set up WPS Office on your device.
- 3. Open Your Spreadsheet: Launch WPS Spreadsheet and open your .xlsx files directly to start editing without lock errors.
Frequently Asked Questions
Why does Excel say my file is locked for editing when nobody else is using it?
This usually happens if Excel crashed previously, leaving a hidden temporary lock file, or if OneDrive is experiencing sync delays. Ensuring Excel is fully closed via Task Manager and verifying your OneDrive sync status can resolve this.
Does co-authoring work on all versions of Microsoft Excel?
No. Co-authoring requires a Microsoft 365 subscription and a modern version of Excel. If a colleague opens the file with an older, unsupported version of Office, the file will be locked for everyone else.
How can I force unlock an Excel file in SharePoint?
If a file is permanently stuck, a SharePoint site administrator can navigate to the document library settings and use the 'Check Out' and 'Check In' features, or end the active session to forcefully release the lock.
