1.2K
It is easy to forget the password for sheet protection in Excel. To be able to edit the table again, the sheet protection must be removed. We will show you a trick how to remove the password for it.
Forgotten password: Unprotect sheets in Excel
To open the spreadsheet you need the unpacking programme 7-Zip or WinRAR.
– Right-click on the file name and select “Rename”.
– Delete the file extension “xlsx” and enter “zip” instead.
– Tip: If you do not see the file extension, click on “View” in Explorer and check “File name extension”.
– Open the table with a “right click” via the menu “7-Zip” – “Open”.
– Open the folder “xl” in 7-Zip and then “worksheets”.
– Here you may find several files with the name sheet stands for a digit).
– Copy the file sheet1.xml to the desktop.
