Fix an Excel Shared Workbook Locked by Your Own Account
Question details
The user needs to edit a shared Excel workbook that is reported as locked by their own account.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Opening a workbook stored on a shared drive for editing.
- Observed behavior
- Excel says the current user has locked the workbook, even though it is not open, or offers only read-only access.
Ask everyone who uses the workbook to close it, and check whether your account has it open on another computer. Make sure you have permission to view files in the shared folder.
Clear a Stale Excel Owner File
Use this method when Excel still reports a lock after everyone has closed the shared workbook.
Close the workbook and Excel on every computer where your account or another user may have it open. Wait briefly for the shared-drive lock to clear.
Open the workbook's shared folder in your file manager and enable its option to show hidden files.
After confirming that nobody is editing the workbook, look for its owner file, typically named like the workbook with a ~$ prefix. Delete that owner file, not the workbook itself.
Open the original workbook from the shared folder in Excel and check whether it is available for editing.

Test a Copy and Ask the File Server Administrator to Release the Lock
Use this method to narrow down a persistent lock or determine whether it affects more than one workbook or user.
Work With Excel Files in WPS Spreadsheet
WPS Office is a free, lightweight alternative with a familiar interface and support for Excel formats, making it easy to move existing spreadsheets into WPS Spreadsheet. It does not release an Excel or file-server lock.

Frequently Asked Questions
Why does Excel say I locked a workbook I already closed?
A previous Excel session, an owner file, or a file-server lock may not have cleared. Close Excel on all computers using the workbook, wait briefly, and try opening it again.
Which file should I remove from the shared folder?
After everyone has closed the workbook, look for its hidden owner file, usually named like the workbook with a ~$ prefix. Delete the owner file only, not the original workbook.
What does it mean if a copied workbook opens normally?
It suggests the issue may involve the original file or its shared-drive lock. Give that result to the file server administrator so they can check the original workbook's lock.
Can WPS Office remove an Excel shared-drive lock?
No. WPS Spreadsheet can open compatible Excel files, but a stale shared-drive lock must be cleared through the relevant Excel sessions or by the file server administrator.




