'%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 During Co-Authoring
Question details
The user is unable to co-author an Excel workbook because the system states the file is locked for editing by another user, even though sharing permissions are configured correctly.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Collaborating on a shared Excel workbook with multiple team members simultaneously.
- Observed behavior
- The workbook restricts access to one person at a time and displays a 'locked for editing by another user' error message, preventing real-time co-authoring.
Verify that your internet connection is stable and ensure the shared file is hosted on a supported cloud platform like OneDrive or SharePoint, as local network drives do not support modern co-authoring.
Force Close Active Sessions and Verify Excel Versions
Orphaned sessions or incompatible Excel versions are the most common reasons a shared file appears locked.
For co-authoring to work, everyone accessing the file must be using a version of Excel that supports the feature, such as Microsoft 365. If even one user opens the file with an older, unsupported version, the file will be locked for everyone else.
Instruct all collaborators to save their work and completely close the Excel application on all their devices.
Ensure everyone is using a Microsoft 365 subscription version of Excel. Standalone versions like Excel 2016 or older do not support real-time co-authoring.
If the file remains locked, open Task Manager (Ctrl + Shift + Esc) on your PC and end any hidden Microsoft Excel background tasks to clear orphaned sessions.
Test the Workbook in Excel for the Web
Opening the file in the web version of Excel can bypass local desktop application cache issues and force the co-authoring session to reset.
Move the File or Create a Copy
If a specific file is experiencing sync glitches or underlying corruption, migrating the data to a fresh workbook can restore sharing capabilities.
Experience Seamless Collaboration with WPS Office
If Microsoft Excel continues to lock files during co-authoring, consider switching to WPS Office. It provides a lightweight, highly compatible, and free alternative with robust built-in cloud collaboration features that make team editing effortless without locking errors.
- 1. Download and Install: Visit the official WPS website to download and install the free WPS Office suite on your device.
- 2. Open Your Spreadsheets: Launch WPS Spreadsheets and open your existing .xlsx files directly with perfect formatting retention.
- 3. Collaborate in Real-Time: Upload the document to WPS Cloud and share the collaboration link with your team to edit together instantly.
Frequently Asked Questions
Does the size of my Excel file affect co-authoring?
Generally, file size does not cause locking issues on the desktop app. However, Excel Online generally supports smooth collaboration for files up to 10 MB. If your file exceeds this limit, it may fail to sync properly in the web view and appear locked.
Why does Excel say my file is locked by myself?
This usually happens if you closed the document abruptly, lost internet connection, or if Excel crashed, leaving an orphaned session on the server. Opening the file in Excel for the Web and closing it properly can usually clear this self-lock.
Can I co-author an Excel file if someone is using an older version of Excel?
No. If a user opens the shared workbook using a standalone version of Excel that does not support modern co-authoring (such as Excel 2016 or earlier), the file will be locked for editing for everyone else until that user closes the file.
