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.