Permission & Access Issues

Fix an Excel Shared Workbook Locked by Your Own Account

Anum MushtaqAnum Mushtaq Nov 22, 2026 868 views

Question details

The user needs to edit a shared Excel workbook that is reported as locked by their own account.

Fix an Excel Shared Workbook Locked by Your 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.
Before you start

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.

Solution 1Recommended

Clear a Stale Excel Owner File

Use this method when Excel still reports a lock after everyone has closed the shared workbook.

1
Close Excel everywhere

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.

2
Show hidden files

Open the workbook's shared folder in your file manager and enable its option to show hidden files.

3
Remove the stale owner file

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.

4
Reopen the workbook

Open the original workbook from the shared folder in Excel and check whether it is available for editing.

Clear a Stale Excel Owner File
If the owner file returns: An active session or server-side lock may still exist. Do not delete files while anyone is editing; ask the file server administrator to investigate.
Free Microsoft Office alternative

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.

Open and edit compatible Microsoft Excel XLS and XLSX filesUse a familiar spreadsheet interface for everyday workbook tasksWork with an accessible copy while an administrator investigates a shared-drive lockUse a free, lightweight office suite
microsoft office alternative - wps office

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.