How to unprotect Excel sheet without password

If you prefer to watch the complete steps in a video, then visit this youtube link:

https://youtu.be/eSTUQk1t1dI

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

 unprotect excel sheet without password

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.

unlock excel forgotten password

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.


7 comments


  • Ryan

    Having the same problem with the sheets saying contents are invalid after re-zipping. The method worked a week ago but does not work now.


  • Amjid

    I have a .xlsm file and this is useless.


  • steph

    Hey, not sure if this works anymore with windows 10 updated recently (writing this as of 6/3/24), and it continues to say the zip file is invalid despite this working flawlessly before. Any insight? Thanks in advance! Would like to know if there’s anything that I need to be doing differently?


  • Simon

    How do you recompress to the zip after editing the XML?


  • Adam

    Use any text editor. It doesn’t matter


Leave a comment

This site is protected by hCaptcha and the hCaptcha Privacy Policy and Terms of Service apply.