October 4, 2017 @
Great post on cracking password on MS office documents. I had a similar problem and instead of cracked the password I removed it. I am not sure if you have heard of this technique so I thought I would share. I was successful with this on a Office 2010 excel document
-Rename the password protected excel document from “file.xlsx” to “file.zip”
-Open the new zip file using winzip. The unzipped file will expose the underlying structure of the excel document
-Now drill down into the XL\worksheets directory where the xml files are stored for the document
-In the worksheets folder you will find the file XML representation of each sheet in the excel workbook. The XML file holds the encrypted password for that specific sheet in the excel document
-Use a XML editor and search for the entry named sheet protection. This where the encrypted password is stored. Since the objective is to use the document, not break the password, we are just going to remove the protection. This is done by highlighting this area and deleting it. Make sure to highlight the complete entry which starts with a “”
-After deleting the sheet protection entry in the XML sheet it will now need to be merged with the original document. Do this by selecting “Update Zip file with changes” when you save the XML file
-Perform this action for each of the protected sheets XML file. After each sheet has been updated and merged with the original document you can change it back to an Excel document by modifying the files extension back to XLSX.
Notify me of new posts by email.