Skip to content

Excel Unprotect Sheet and Workbook

Remove sheet and workbook protection from an .xlsx file you own, so locked cells and the sheet structure can be edited again. It cannot remove a password that opens the file.

Excel Unprotect

Remove worksheet protection from an unencrypted Excel workbook locally.

Maximum file size: 25 MB per file. You can also drag files here.

Supported scope and limitations

Password-encrypted XLSX files at the container level are rejected. This removes sheet protection flags only; it does not crack workbook-open passwords or recover lost VBA project passwords. Inspect the downloaded file before sharing. Nothing is uploaded.

Examples contain invented demonstration data. Replace it before using any export.

Privacy: files are processed in your browser and are never uploaded.

Unprotect Excel sheet and workbook protection without the password: choose the .xlsx file in the tool below and download unprotected.xlsx. It removes sheet and workbook protection and leaves cells, formulas and formatting unchanged. It cannot remove a password that is needed to open the file, because that encrypts the workbook.

Unprotect Excel sheet tool at a glance

Input Excel workbook (.xlsx)
Output unprotected.xlsx, same content without protection
Removes Sheet protection (sheetProtection), workbook structure protection (workbookProtection)
Does not remove Password to open (encryption), VBA project passwords
File limit 25 MB per file
Privacy Runs in your browser; the workbook is not uploaded

How to unprotect Excel sheet protection in 4 steps

  1. Save as .xlsx if needed. Older .xls files must be saved as .xlsx in Excel, LibreOffice or Google Sheets first.
  2. Choose the workbook. Select the .xlsx file. The result reports how many sheets had protection removed.
  3. Download unprotected.xlsx. Click Download: unprotected.xlsx and open it in Excel.
  4. Edit, then protect again if needed. Locked cells are editable again. To protect it with a password you will remember, use Review > Protect Sheet.

How do I unprotect an Excel sheet if I forgot the password?

Run the .xlsx through this tool. Sheet protection is an editing lock stored inside the file, so it can be removed without knowing the password.

An .xlsx file is a ZIP of XML files. Protection is a <sheetProtection> element in each protected sheet’s XML and a <workbookProtection> element in xl/workbook.xml. The tool removes those elements and rezips the workbook. Nothing else is changed.

Can I remove the password that opens an Excel file?

No. A password to open (File > Info > Protect Workbook > Encrypt with Password) encrypts the whole file, and the data cannot be read without it.

The tool rejects encrypted workbooks rather than trying to guess passwords. If it is your file, check old notes or password managers, or ask whoever created it.

Does unprotecting a sheet change my data or formulas?

No. Only the protection settings are removed. Values, formulas, formatting, charts and sheet names are copied over as they were.

Example: a workbook with three protected sheets, one named “Budget & Plan” with =SUM(B2:B3), comes back with all three sheets unprotected and the same formula and values.

Unprotect Excel sheet example result: 2 sheets unprotected, unprotected.xlsx ready to download
Illustrative result from this unprotect Excel sheet tool using a fictional two-sheet test workbook.

How do I unprotect an Excel workbook structure?

Workbook structure protection, which stops you adding, renaming or deleting sheets, is removed in the same step as sheet protection.

Why does Excel say the cell is on a protected sheet?

Excel shows that message when you try to type in a locked cell on a protected sheet. By default every cell is locked, and the lock only takes effect once someone turns on Review > Protect Sheet.

If you know the password, Review > Unprotect Sheet is the quickest fix. If nobody remembers it, unprotect Excel sheet protection with this tool instead. Microsoft notes that sheet and workbook protection is not a security feature: it stops accidental edits, not someone who wants to read the data. For files that must stay private, use a password to open, which encrypts the file (Microsoft: Protect a workbook).

How does this unprotect Excel sheet tool compare with other options?

The main differences are cost, whether your file leaves your device, and what you get back. This table describes each option in general terms.

Option Cost File uploaded? Output Main limitation
This tool Free No, runs in your browser Sheet + workbook protection Cannot remove open passwords
Excel: Review > Unprotect Sheet Free No One sheet at a time Needs the password
Rename to .zip and edit the XML by hand Free No Any protection element Fiddly; easy to break the file
VBA macros found in forums Free No Older protection only Needs macros enabled; varies by Excel version

Is this unprotect Excel sheet tool private?

Yes. The file is processed by JavaScript in a background worker in your browser tab and is not uploaded to a Calcenzo or FileFix server. Downloads are created in your browser’s memory. On a shared computer, use Clear files and results or close the tab when you finish.

Working with exported spreadsheet data? See also the CSV encoding converter, CSV diff and JSON to CSV converter.

Sources

Questions about this tool

Can I unprotect an Excel sheet if I forgot the password?

Yes for sheet and workbook protection, because that password only switches on an editing lock inside the file. The tool removes the lock and leaves your data alone.

Can it remove the password that opens the file?

No. A password to open encrypts the workbook, and the data cannot be read without it. The tool rejects encrypted files.

Does unprotecting change my formulas or data?

No. Only the protection settings are removed. Cells, formulas, formatting, charts and sheet names are copied across unchanged.

Does it work with .xls or .xlsm files?

It accepts .xlsx. Save an older .xls as .xlsx first. Keep a copy of the original if the file contains macros.

Is it legal to unprotect an Excel sheet?

Removing protection from your own files, or files you are allowed to edit, is normal. Do not use it to get around restrictions on someone else's work.

Review the supported formats and limitations before using an output file. File processing happens in your browser.