In this blog, i want to share my some of tricks and experiences about general hacking like unlocking password protected PDF, EXCEL, WORD, PPT etc.
Today i am going to teach you, how to editing and modify of any password protected .xlsx file.
First of all you have a password protected EXCEL file and after that apply the following step:
1) You have to change file extension. For example test.xlsx to test.zip
i) there are two way to change the extension as follow:
a) directly double click on the particular file.
b) through command prompt.
2) After changing the extension, open the .zip folder and find sheet1.xml file.
i) test.zip\xl\worksheets
ii) copy that sheet1.xml file.
iii) open in notepad and search "password" and delete in between the quotes "<sheetProtection password="C71F" sheet="1" objects="1" scenarios="1" selectLockedCells="1" selectUnlockedCells="1"/>".
iv) save the file and replace the original file into the zip folder.
v) rename .zip folder to .xlsx
3) Here you go the file is editable and unprotected.
4) Try it with the test.xlsx. Share it also.
if you have any query please let me know.
Important: This article is for educational purposes. Try this method for opening ONLY your own files.THANKS
Today i am going to teach you, how to editing and modify of any password protected .xlsx file.
First of all you have a password protected EXCEL file and after that apply the following step:
1) You have to change file extension. For example test.xlsx to test.zip
i) there are two way to change the extension as follow:
a) directly double click on the particular file.
b) through command prompt.
2) After changing the extension, open the .zip folder and find sheet1.xml file.
i) test.zip\xl\worksheets
ii) copy that sheet1.xml file.
iii) open in notepad and search "password" and delete in between the quotes "<sheetProtection password="C71F" sheet="1" objects="1" scenarios="1" selectLockedCells="1" selectUnlockedCells="1"/>".
iv) save the file and replace the original file into the zip folder.
v) rename .zip folder to .xlsx
3) Here you go the file is editable and unprotected.
4) Try it with the test.xlsx. Share it also.
if you have any query please let me know.
Important: This article is for educational purposes. Try this method for opening ONLY your own files.THANKS