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.EXErunning 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.
- Open File Explorer and browse to the directory containing the locked workbook.
- Click View > Show > Hidden items to ensure hidden system files are visible.
- Look for a dim or transparent file matching the name of your spreadsheet with a
~$prefix (e.g.~$FinancialModel.xlsx). - Select the lock file and press Shift + Delete to remove it permanently.
- 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.
- On the computer of the user named in the lock prompt (or your own PC), press Ctrl + Shift + Esc to launch Task Manager.
- Look under Processes for Microsoft Excel.
- If an Excel instance is visible despite no open windows, right-click it and select End task.
- 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.
- In File Explorer, look at the top command ribbon.
- Click View.
- Ensure neither Preview pane nor Details pane is highlighted or ticked.
- 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.
- On the file server, open Computer Management (
compmgmt.msc). - Navigate to System Tools > Shared Folders > Open Files.
- Locate the locked spreadsheet in the right-hand list.
- Right-click the entry and select Close Open File.
- Clients will immediately be able to access the file for editing.