Remove workbook‑structure protection in Excel

Structure protection is not sheet protection

Excel has two separate edit locks and people often confuse them:

• Protect Sheet locks the cells within a worksheet — you cannot edit values or formulas. Its flag lives in each worksheet's XML as <sheetProtection>.
• Protect Workbook (structure) locks the set of sheets — you cannot add, delete, rename, move, copy, hide, or unhide tabs. Its flag lives once in xl/workbook.xml as <workbookProtection>.

If your tabs are greyed out in the right‑click menu but the cells themselves are editable, it is workbook‑structure protection you are dealing with.

How to remove it

Just like sheet protection, this is an edit lock, not encryption — Excel stores only a hash of the password. Removing the <workbookProtection> tag re‑enables all the tab operations.

1. Drop a copy of the file onto the unlock tool. It clears both <workbookProtection> in xl/workbook.xml and any <sheetProtection> flags in one pass, right in your browser.
2. Download the result — you can now add, delete, move, and unhide sheets freely.

To do it by hand, follow the manual ZIP method but open xl/workbook.xml instead of a worksheet, and delete the single <workbookProtection .../> tag.

The encryption caveat

As always, this only removes edit protection. If the workbook asks for a password before it opens, that is AES encryption of the whole file — a completely different mechanism that cannot be stripped without the real password.

Unlock it in seconds instead

The manual route works, but our free in‑browser tool does the same thing in one drop — nothing is uploaded, everything runs on your device.

Frequently asked

Related guides

Fix “the cell you’re trying to change is on a protected sheet” · Unlock a protected .xls file (old Excel format) · Unprotect Sheet greyed out in Excel for the web