How to unlock a protected Excel sheet
Updated 3 June 2026
If Excel says “The cell or chart you’re trying to change is on a protected sheet,” you’re hitting worksheet protection — and it’s far weaker than it looks.
Sheet protection isn’t encryption
An .xlsx file is really a ZIP of XML. Worksheet protection is stored as a single <sheetProtection> tag inside the sheet’s XML — a flag Excel honours voluntarily. Removing that tag unlocks editing instantly, and you don’t need the password that was set.
The same applies to workbook protection (the lock on adding, deleting or reordering sheets).
How to remove it
- Open the Excel unlocker.
- Drop your
.xlsxor.xlsmfile in — it’s processed in your browser, never uploaded. - Download the unlocked workbook. Your data, formulas and formatting are untouched; only the protection is gone.
The one case this won’t fix
If Excel asks for a password just to open the file, that’s a different thing entirely — the workbook is encrypted (AES), not merely protected. Removing a flag can’t help.
- Know the password? Open it in Excel, remove the open-password under File → Info → Protect Workbook → Encrypt with Password (clear the box), and save.
- Forgotten it? The password has to be recovered by computation — request recovery and we’ll assess it, pay-on-success.
Legal note
Only unlock spreadsheets you own or are authorised to edit. Sheet protection is a convenience feature, not a security control — but that’s no licence to open other people’s files.