Unprotect/Remove Excel Password

Posted on by
  1. Change the extension of you Excel file from .xlsx to .zip
  2. Extract these XML files outside the folder,they represent the worksheets in the Excel file.
    1. Location: xl -> worksheets -> *.xml
  3. Modified codes using simple “Notepad”.
    1. Open XML File & Delete  Excel v. 2007-10 “sheetProtection password=… />” v. 2013 – “sheetProtection algorithmName=…/>”
  4. Save & Close Xml File
  5. The modified XML file should be put again in the zipped file to replace the old XML files.
  6. Run File
 
 
 

Leave a Reply

Your email address will not be published. Required fields are marked *