How to Fix Excel Cloud Workbook Locked by Another User
Question details
The user is unable to save a cloud-based Excel workbook because the system incorrectly reports it as being locked for editing by another user.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Attempting to save modifications to an Excel workbook stored on a cloud service like OneDrive or SharePoint.
- Observed behavior
- Excel displays an error stating the file is locked for editing by another user, preventing the current user from saving their changes, even when no one else is actively using the file.
Before proceeding, use 'Save As' to save a local copy of your workbook to your computer's hard drive so you do not lose any unsaved work.
Force Close Excel and Wait for Server Synchronization
Resolve ghost sessions and background locks by terminating all Excel processes and allowing the cloud server to release the lock.
Often, a temporary disruption in your network connection or an improperly closed application causes the cloud server to retain a 'lock' on the file. Terminating all active instances of Excel helps clear these stuck sessions.
Ensure that the file is completely closed on your computer, your mobile devices, and anywhere else you might have opened it recently.
Press Ctrl + Shift + Esc to open Task Manager on Windows. Scroll through the list to find 'Microsoft Excel', right-click it, and select 'End task' to force close any hidden processes.
Wait approximately 5 to 10 minutes. This allows the OneDrive or SharePoint server enough time to recognize that the session has ended and automatically release the lock on your workbook.
Open Excel and access your cloud workbook again. The locked file error should now be resolved.

Check Excel for the Web and Co-authoring Status
Ensure the file isn't stuck open in a web browser tab or currently being edited by someone without co-authoring capabilities enabled.
Try WPS Office for Seamless Spreadsheet Editing
If you frequently encounter file locking issues and synchronization delays with Microsoft Excel, consider trying WPS Office. It is a free, lightweight, and highly compatible Office alternative that makes creating, editing, and sharing spreadsheets hassle-free.
- 1. Download WPS Office: Visit the official WPS website and download the free installer for your operating system.
- 2. Install the software: Run the downloaded installer and follow the simple on-screen instructions to set up WPS Office.
- 3. Open your spreadsheets: Launch WPS Spreadsheet and open your existing Excel workbooks to enjoy seamless editing.

Frequently Asked Questions
Why does Excel say a file is locked when I am the only user?
This usually happens due to a 'ghost session' where the cloud server (like OneDrive or SharePoint) thinks a previous session is still active. A dropped internet connection, a browser crash, or an improper app shutdown can leave the file locked on the server temporarily.
How do I force unlock an Excel file in SharePoint?
If you have administrator rights, you can navigate to the SharePoint document library settings and use 'Manage files which have no checked in version', or require check-out/check-in to manually override locks. Otherwise, waiting 10 minutes usually clears temporary server locks automatically.
Does AutoSave affect file locking in Excel?
Yes. For co-authoring to work without locking the file for other users, AutoSave must be enabled. Additionally, the file must be saved in a modern format (.xlsx, .xlsm, or .xlsb) and stored on OneDrive or SharePoint.
Can I bypass the locked file warning to edit anyway?
You cannot directly bypass an exclusive lock to edit the original file. However, you can choose to open the file in Read-Only mode, or use 'Save As' to create a new local copy, make your edits, and merge the changes later when the original file is unlocked.




