How to Fix Excel File Locked for Editing by Another User Error

Accessing a shared financial spreadsheet or inventory tracker stored on a corporate local network drive or OneDrive only to be blocked by the prompt: “File In Use: ‘Workbook.xlsx’ is locked for editing by ‘another user’. Open ‘Read-Only’ or, click ‘Notify’ to open read-only and receive notification when the document is no longer in use” prevents updates – especially when the named user confirmed they closed the file hours ago.

Why Does Excel Report a File Is Locked for Editing?

Microsoft Excel creates temporary hidden lock files (owner files) to preserve data integrity across multi-user environments:

  • Orphaned Owner Lock File (~$Workbook.xlsx): When Excel crashes or a network connection drops unexpectedly, the temporary lock file is left behind in the folder directory.
  • Lingering Background Excel Process: A ghost instance of EXCEL.EXE running in Windows Task Manager on a co-worker PC holding an exclusive read/write file handle.
  • Stale SMB Network File Sessions: The network file server (Windows Server or Linux Samba NAS) retaining an active client lock lease after an untidy client disconnect.
  • Windows Explorer Preview Pane Lock: The Windows File Explorer Details or Preview pane loading the workbook to generate thumbnails, creating a file lock.

1. Delete the Hidden Owner Lock File (~$Filename.xlsx)

Removing the orphaned lock file restores write access immediately.

  1. Open File Explorer and browse to the directory containing the locked workbook.
  2. Click View > Show > Hidden items to ensure hidden system files are visible.
  3. Look for a dim or transparent file matching the name of your spreadsheet with a ~$ prefix (e.g. ~$FinancialModel.xlsx).
  4. Select the lock file and press Shift + Delete to remove it permanently.
  5. Open the original workbook. It will now launch in full read/write mode.

2. Terminate Ghost Excel Processes in Task Manager

If another user workstation crashed while editing, their computer may still hold an open handle.

  1. On the computer of the user named in the lock prompt (or your own PC), press Ctrl + Shift + Esc to launch Task Manager.
  2. Look under Processes for Microsoft Excel.
  3. If an Excel instance is visible despite no open windows, right-click it and select End task.
  4. Re-open the workbook to confirm that the file lock has cleared.

3. Disable File Explorer Preview and Details Panes

The File Explorer preview engine frequently locks files as read-only while parsing content.

  1. In File Explorer, look at the top command ribbon.
  2. Click View.
  3. Ensure neither Preview pane nor Details pane is highlighted or ticked.
  4. Close and re-open File Explorer, then double-click your spreadsheet.

4. Close Open File Sessions on Windows File Server

If the file is hosted on a central Windows Server share, server administrators can release the lock directly.

  1. On the file server, open Computer Management (compmgmt.msc).
  2. Navigate to System Tools > Shared Folders > Open Files.
  3. Locate the locked spreadsheet in the right-hand list.
  4. Right-click the entry and select Close Open File.
  5. Clients will immediately be able to access the file for editing.

Get the best tech tips delivered straight to your inbox.

Join thousands of readers mastering Apple, Google, Microsoft, and Linux.