- Change the extension of you Excel file from .xlsx to .zip
- Extract these XML files outside the folder,they represent the worksheets in the Excel file.
- Location: xl -> worksheets -> *.xml
- Modified codes using simple “Notepad”.
- Open XML File & Delete Excel v. 2007-10 “sheetProtection password=… />” v. 2013 – “sheetProtection algorithmName=…/>”
- Save & Close Xml File
- The modified XML file should be put again in the zipped file to replace the old XML files.
- Run File
Monthly Archives: April 2019
Windows Update Through Proxy
- To configure a proxy server by using the Netsh.exe tool
netsh winhttp set proxy proxyservername:portnumber
Exemplo: netsh winhttp set proxy 10.12.200.222:8080
- To remove a proxy server by using the Netsh.exe tool
netsh winhttp reset proxy