Excel: Edit the XML inside an XLSX file
- by Andomar
An Excel XLSX file is a zip archive containing several XML files. I tried to extract all the XML files, and edit xl\connections.xml using an XML editor. That's because I have to change 20+ connections to point to a different server.
When I open the edited archive in Excel, it refuses the changes and repairs the file.
Is there a way to edit the XML files inside an XML archive?