Unprotect/Remove Excel Password

  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