How to Unprotect an Excel Workbook
Can't add a new tab, rename a sheet, or unhide a hidden one — and the options are greyed out? Your workbook has structure protection switched on. Like sheet protection, it's an editing restriction rather than encryption, so you can remove it for free without the password. Here's how.
Workbook protection vs. sheet protection
These two are easy to mix up, so it's worth being precise:
- Workbook (structure) protection locks the set of sheets — you can't add, delete, move, copy, rename, hide or unhide worksheets. That's what this guide removes.
- Sheet protection locks the cells within one sheet — you can't edit values. See our sheet-protection guide for that.
A workbook can have both at once. XLockFree removes both in a single pass.
Remove workbook protection with XLockFree
- Open the XLockFree unlocker. No install, no account, any device.
- Upload your workbook. Drop the
.xlsxor.xlsmfile onto the page and leave the password field blank. - Click "Unlock & Download". XLockFree removes the workbook structure lock (and any sheet locks) and downloads the unlocked copy. Watch for the Workbook badge.
- Open the file in Excel. Right-click any sheet tab — Insert, Delete, Rename, Move and Unhide are all available again.
Nothing is lost. Removing structure protection doesn't touch your worksheets or data — it only re-enables the sheet-management commands Excel had greyed out.
Need to unhide a "very hidden" sheet?
Workbook protection is often paired with sheets set to xlSheetVeryHidden — sheets you can't even see
in the Unhide dialog. Once the workbook is unprotected, you can reveal them through the VBA editor
(Alt + F11 → set the sheet's Visible property to xlSheetVisible),
or simply keep working in the now-unlocked file.
Batch tip: Managing a folder of locked templates? Drop them all into XLockFree at once and download the unprotected set as a single ZIP.
Troubleshooting
Sheet tab options are still greyed out
Ensure you opened the downloaded unlocked_ file. If cells are also locked, that's separate sheet protection — XLockFree removes it in the same download, so re-check the badges.
Excel asks for a password to open the file
Then it's encrypted, not just structure-protected. Follow the encrypted-file guide and provide the open password.
Frequently asked questions
How do I unprotect a workbook without the password?
Workbook structure protection isn't encryption, so it can be removed without the password. Upload the file to XLockFree and it removes the lock instantly.
What does workbook protection actually block?
It prevents changing the workbook structure — adding, deleting, moving, renaming, hiding or unhiding worksheets. It does not lock individual cells.
Is workbook protection the same as a file open password?
No. Workbook protection only restricts sheet management and needs no password to remove. A file open password encrypts the whole file.
Will unprotecting affect my sheets or data?
No. Only the structure lock is removed. All worksheets, data, formulas and formatting remain exactly as they were.