The message swears a colleague has your file open. The colleague swears they closed it hours ago — or the user it names is you. Locked-for-editing errors regularly outlive the session that caused them. Here is how to clear them without risking work saved by anyone else.
✍️ Technical Anshu🪟 Windows 11⏱️ 6 minute read
🎥 Watch the full video for the complete Excel and Windows troubleshooting method used in IT support
Every time Excel opens a workbook for editing, it plants a hidden owner file beside it and, on networks, the server tracks the open session. Crashes, forced shutdowns and dropped connections can leave both behind — and Excel then reports the file as locked by a user who is no longer there. The safe way out is a ladder: prove it, work around it, then clear it.
Microsoft Excel — File in Use dialog
Sales-Report.xlsx is locked for editing by 'R. Sharma'.
📖 Open Read-Only — view and copy the file, cannot save over itSafe
🔔 Notify — Excel tells you when the file becomes freePatient
👻 The named user — closed the file hours ago, they insistGhost lock
☝️ The real File in Use dialog — the named user is often a leftover session, not a person at a keyboard
1
First Prove Whether Anyone Really Has It Open
Never force anything until you know the lock is fake — sometimes it is not:
Ask the named user to check properly: Excel may be closed on screen while a crashed EXCEL.EXE still runs underneath. On their machine, Task Manager → end any leftover EXCEL.EXE, and the lock releases legitimately
If the message names you, the same applies to your own PC — a crashed earlier session of yours is the usual author
Only when every real Excel is confirmed closed do you treat the lock as an orphan and move on
2
Keep Working — Read-Only Plus Save As
Choose Open Read-Only in the dialog. You can view everything and copy data out
If work cannot wait, use Save As to save your changes under a new name, and tell your team clearly which file is now the live one
Be honest about the cost: this creates two versions that someone must merge later. For a five-minute wait, Notify is the cheaper option — Excel pops up the moment the file frees
3
Delete the Orphaned Owner File
While a workbook is open, Excel keeps a tiny hidden lock file beside it, named like ~$Sales-Report.xlsx. A crash can leave it behind, and Excel then believes the file is still open:
Confirm step one is done — nobody has the workbook open anywhere. This step is only safe on that condition
In the workbook's folder, turn on View → Hidden items in File Explorer so the lock file becomes visible
Delete only the ~$ file — it is a small marker of a few hundred bytes. The real workbook (.xlsx) is never touched
Open the workbook again — the locked message is gone
4
Close the Ghost Session on the File Server — IT Step
If the file lives on a shared drive and the lock survives everything above, a server-side session is holding it — often from a crashed PC or a dropped VPN connection
On the server (or ask IT): open Computer Management → Shared Folders → Open Files
Find the workbook in the list, right-click it and choose Close Open File
The ghost session drops and the file opens normally. This is the definitive fix for locks that no workstation change can clear
🔒 Two things never to do: never delete or overwrite the real workbook to "solve" a lock, and never delete the ~$ owner file while someone might genuinely be editing — you would let two people save over each other and silently lose one version. And if the file lives in OneDrive or SharePoint rather than a shared drive, locks are handled by co-authoring — check the checked-out state of the file online instead of hunting lock files.
🎥 Watch the Complete Fix in the Full Video
The video demonstrates the full troubleshooting approach on a real Windows 11 system — verify first, then fix, in that order.
Because your earlier Excel session crashed or was force-closed while the file was open, leaving its lock behind. Excel reads the leftover owner file and concludes the workbook is still in use — by you. Confirm no Excel process is running, then delete the small hidden owner file that starts with ~$ in the same folder.
Is deleting the ~$ file dangerous
The ~$ file is only a lock marker, not your data — deleting it never harms the workbook itself. It is dangerous in exactly one situation: if someone really is editing the file at that moment, because you would remove the protection that stops two people saving over each other. Always confirm the file is closed everywhere first.
Does the same fix work for files in OneDrive or SharePoint
Not directly. Cloud files use co-authoring, so locks are managed online rather than by local owner files. If a cloud file reports as locked, check whether it is checked out to someone in the document library, and give recent edits a few minutes to sync closed before treating it as stuck.
This guide is based on the Technical Anshu Excel copy paste bug video • Stuck on any step? Ask in the video comments — help is available there 🙏