843
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.
