Excel 2007-2010 - Password Removal

To remove a password from a password protected Excel document, do the following:

1. Change the file extension to .zip from .xlsx.
2. Extract the whole content of zip file.
3. Search for xml format of targeted sheet. It is in "xl\worksheets" directory (eg: sheet1.xml).
4. Open the xml file of targeted sheet in a text editor (notepad++)
5. Search for "sheetProtection" word in that xml file and remove it (remove the whole thing from <sheetProtection ... to />
6. Save this edited xml file and re-add everything to the zip archive.
7. Finally, change the extension from .zip to .xlsx.