Permission & Access Issues

How to Fix Excel Cloud Workbook Locked by Another User

Aamir Naveed AkramAamir Naveed Akram Oct 28, 2026 870 views

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 you start

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.

Solution 1Recommended

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.

1
Close the workbook on all devices

Ensure that the file is completely closed on your computer, your mobile devices, and anywhere else you might have opened it recently.

2
End background Excel processes

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.

3
Wait for the server timeout

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.

4
Reopen the file

Open Excel and access your cloud workbook again. The locked file error should now be resolved.

Force Close Excel and Wait for Server Synchronization
Tip: If you are using a Mac, you can force quit Excel by pressing Option + Command + Esc, selecting Microsoft Excel, and clicking 'Force Quit'.
Free Microsoft Office alternative

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. 1. Download WPS Office: Visit the official WPS website and download the free installer for your operating system.
  2. 2. Install the software: Run the downloaded installer and follow the simple on-screen instructions to set up WPS Office.
  3. 3. Open your spreadsheets: Launch WPS Spreadsheet and open your existing Excel workbooks to enjoy seamless editing.
Fully compatible with Microsoft Excel formats including .xlsx, .xls, and .csv.Free and lightweight, avoiding heavy background processes that can cause file locks.Familiar user interface with a zero learning curve for quick and easy migration.Built-in cloud collaboration tools for smooth multi-user editing without exclusive lock errors.
QA img-9

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.