How to Unprotect Excel Sheet (standard and force)

Message when trying to edit a protect Microsoft Excel sheet:

How to Unprotect Excel Sheet: The cell or chart you`re trying to change is on a protected sheet.
The cell or chart you`re trying to change is on a protected sheet.

There are several ways:

Article in other languages:
🇪🇸 – Cómo desbloquear una hoja protegida de Excel
🇷🇺 – Как снять защиту страницы Excel

The standard way to unprotect Excel sheet

  1. Open the Review tab;
  2. Click Unprotect Sheet;
  3. Enter the password to protect the sheet.
The standard way to unprotect Excel sheet
The standard way to unprotect Microsoft Excel sheet

Force way to unprotect Excel sheet

This method of unprotecting an Excel page is suitable for Microsoft Office: 2019, 2016, 2013, 2010, 2007. It is used when an Excel worksheet cannot be unprotected in the standard way.

1. Change the xlsx file extension to zip

If you do not see the .xlsx extension at the end of the file name, enable the display of the file name extension in the Explorer settings.

Windows 10:

  1. Click View on the folder menu;
  2. Check the box for the File name extension.
Change the Microsoft Excel file extension
Change the Microsoft Excel file extension

2. Open the archive

  1. Open folder xl;
  2. Open folder worksheets.

3. Open a protected xml sheet

Open a protected Excel sheet (for example sheet1.xml) with a text editor (Notepad).

Search: sheetProtection

Remove all contents of sheetProtection, starting from including brackets.

Removing protection from Microsoft Excel sheet
Removing protection from a Microsoft Excel page file

4. Save the modified file

Close the editor and save the xml file in the worksheets folder.

5. Change the zip file extension to xlsx

Return the extension to the document from zip to xlsx.

If you need to remove protection from several sheets, each sheet needs to be edited separately.

💡 If the document has many sheets, move the sheet from which you want to remove protection to the top of the document. The sheets are numbered in order in the document, your sheet will become sheet1.xml

Password change

In some cases, unprotecting a sheet may affect related documents (Microsoft Excel will notify you when it starts).

In this case, it is recommended to change the contents of the tag of the protected page to the following value:

<sheetProtection algorithmName="SHA-512" hashValue="ZEXIHSO8adnzAM0euNbPG9tNX4sf5dhHesITeYXSrG+1Rk7QkVvvcBk7iyFDvR+Yo+udd9w+IT8KY9/2wjiVlA==" saltValue="jsE92cIn81NKxxJP+7EIRw==" spinCount="100000" sheet="1" objects="1" scenarios="1"/>

Then follow the assembly procedure and change the archive extension.

Password on the protected page will be: 123456


Several ways to unprotect a Microsoft Excel page.

Leave a Reply

Adblock
detector