How to Unprotect an Excel Workbook Without a Password

Updated March 2026 · 4 min read

Workbook protection in Excel prevents structural changes — you can't add, delete, rename, move, or hide sheets. This is different from sheet protection, which locks individual cells. Here's how to remove workbook protection when you've forgotten the password.

Workbook Protection vs. Sheet Protection

Feature	Sheet Protection	Workbook Protection
What it locks	Cell editing, formatting	Sheet tabs (add, delete, rename, move)
XML tag	`<sheetProtection>`	`<workbookProtection>`
Where to set it	Review → Protect Sheet	Review → Protect Workbook
Removable?	Yes	Yes

Remove workbook protection instantly

XL Unlocker removes workbook structure protection along with all other protection types — free and private.

Unprotect Your Workbook

How It Works Technically

Workbook protection is stored in the xl/workbook.xml file as a <workbookProtection> tag. This tag contains attributes like lockStructure="1" and an optional password hash. Removing this tag entirely restores full workbook structure access.

Signs Your Workbook Is Protected

Right-clicking a sheet tab shows grayed-out options (Insert, Delete, Rename, Move/Copy)
The "Protect Workbook" button in the Review tab appears highlighted/pressed
You can edit cells but can't reorganize sheets

Steps to Unprotect

Go to XL Unlocker
Confirm you have authorization and upload your .xlsx or .xlsm file
The tool detects and removes the <workbookProtection> tag
Download the unlocked file — sheet tabs are now fully accessible