Excel says “locked for editing” — how to unlock it
Updated 3 June 2026
“Locked for editing” in Excel covers two completely different situations. Fixing it starts with knowing which one you have.
1. “Locked for editing by another user”
This means someone (sometimes a ghost of your own past session) has the file open, so Excel opens it read-only. The file isn’t protected — it’s just in use.
- Shared/network or SharePoint file: ask whoever has it open to close it, or wait for the lock to clear. If it’s stuck, an admin can release the lock.
- A stale lock file: Office leaves a hidden owner file named
~$filename.xlsxnext to the document. If everyone has definitely closed it, deleting that~$…file clears the “locked for editing” state. - Your own session: if Excel crashed, the lock can linger — fully quit Excel (Task Manager / Activity Monitor) and reopen.
This isn’t something a tool unlocks — it’s a coordination/lock issue, not protection.
2. The sheet itself is protected
If you can open the file but Excel says “the cell or chart is on a protected sheet,” that’s worksheet protection — a removable flag, not encryption, and you don’t need the password that was set.
- Open the Excel unlocker.
- Drop in your
.xlsx/.xlsm— it’s processed in your browser, never uploaded. - Download the unlocked workbook.
3. It asks for a password to open
That’s real encryption. If you know the password, open it and clear it in Excel; if you’ve forgotten it, request recovery (pay-on-success).
Quick diagnosis
- “…by another user” → it’s in use; close it elsewhere or clear the
~$lock file. - Opens, but cells won’t edit → protected sheet; use the Excel unlocker.
- Won’t open without a password → encrypted; recovery.