How to unprotect Excel sheet without password
If you prefer to watch the complete steps in a video, then visit this youtube link:
Below are the steps to unlock any Excel sheet if you forgot the password
If your file is .xls then save it as .xlsx if it doesn't have any macros or .xlsm if it has macros. Let us assume your file name is ProtectedWorkbook.xlsx
1. Rename your file by adding .zip to its extension. In our case we will rename it to be ProtectedWorkbook.xlsx.zip
2. Now open the zip file with windows or any program.
3. Browse to the path xl > worksheets folder
4. You will find an xml file for each sheet. Extract the protected sheet xml file to your local drive. In our case, its name is sheet1.xml
5. Right click the extracted sheet1.xml file and select edit to open it in notepad or any other editing software.
6. Find an delete the text starting by <sheetProtection and till the closing >. In other words, from the <sheetProtection till the first > occurrence.
7. Save and close the sheet1.xml file
8. Return the edited sheet1.xml file to overwrite the original one in the zip folder.
9. Close the zip file
10. Rename the file ProtectedWorkbook.xlsx.zip by removing the .zip extension
Your sheet is now unprotected.
I also had to edit a file in the layer above the sheets called workbook.
I searched for protected and removed the xml in a similar manner to the sheets.
Then the sheets could be unhidden and I could see my data again.
This is a simple method that works well.
Thank you for this.
Nope, only files that show up look different:
6DataSpaces
EncryptionInfo
EncryptedPackage
This worked like a charm for me, but only after I watched the video at :30 that said add to step 6 to delete the text starting by <sheetProtection all the way to <pageMargins".
It worked for me. Thank you
This process doesnt seem to work with Win 11 unless i am missing something
Leave a comment