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?