Open password protected XLSX Sheets

Hello everyone,

This week we will see, how to open a password protected excel sheet…

Step 1 : Rename the extension of the excel file as .zip as shown, you can also rename it through Command Prompt Renaming the extension of any file

Step 2 : Extract the .zip file and navigate to xl -> Worksheets -> sheet 1 ( or name in document)

Step 3 : Open it with notepad and delete the <sheetProtection> tag completely as shown below

Step 4 : Save it and copy the sheet.xml and paste it in the original .zip excel document in the same path as shown

Step 5 : Rename the extension of original .zip to .xlsx and open the file

Step 6 : Ta-Da !!!

NOTE :

THIS TRICK IS ONLY APPLICABLE TO PASSWORD PROTECTED SHEETS

IT IS NOT APPLICABLE TO PASSWORD PROTECTED .xlsx DOCUMENTS