ExcelTool.io

Unlock Excel - Find Out Why Your File Is Locked

Sheet protection, encryption, 'locked for editing by another user', read-only mode or a VBA lock - this page tells you which one you have and fixes the ones a tool can, checked entirely in your browser.

This diagnoses the lock type; it fixes removable ones and is honest about the rest. More

Some locks are not something any in-browser tool can remove: a file that is "locked for editing by another user" is open elsewhere, and a file encrypted with a password you don't have cannot be read. This page tells you exactly which lock you have and removes the ones it can, without uploading anything.

Drop your file here or choose a file

Opened on your device - never uploaded · up to 50MB

Supports .xlsx, .xlsm, .xls · or paste a file from your clipboard

or download protected-sample.xlsx

Which Kind of Locked Excel File Do You Have?

"Locked" means five different things in Excel, and most of them are not what an unlock tool removes. Match your symptom first - the diagnosis above confirms the ones that live inside the file.

SymptomWhat it isThe fix
File opens, but cells or sheets can't be editedSheet or workbook protectionRemoved above instantly - drop the file in
Excel asks for a password before opening the filePassword-to-open encryptionDecrypt with the password at the password remover; without it, see recovery
"Locked for editing by another user"The file is open elsewhere (a collaboration lock)No tool needed - close the other session, delete the stray ~$file.xlsx owner file, or wait for the lock to clear
Banner says Read-Only or Protected ViewA safety mode for downloaded or shared filesClick Enable Editing, or clear the file's Read-only attribute in Properties
Macros won't show; VBAProject asks for a passwordA VBA project lockUnlock it in the VBA editor with the password, or strip the project

"Locked for Editing by Another User"

This is the most common lock that is not inside the file, and the one US searches for "unlock excel file" most often mean. When a workbook is opened, Excel writes a hidden owner file beside it -~$yourfile.xlsx - recording who has it open. If the app crashes or a cloud client (OneDrive, SharePoint, Dropbox) holds the file, that owner file can be left behind and Excel keeps reporting the workbook as locked. Nothing is wrong with your data: close the other session, delete the stray ~$ file if it lingers, or wait for the lock to time out. No tool - including this one - needs to touch the file.

What the Diagnosis Reads

Your file is inspected entirely in your browser; it is never uploaded. The tool reads the workbook structure, reports which sheets are protected and whether the workbook, read-only, encryption or VBA locks are present, and removes the ones that are removable on the spot. For the full explanation of why editing locks come off without the password, see the Excel password remover.

Frequently Asked Questions

Related Tools