Forum Discussion
Xml file storage location
Hi,
I am running office 365 and am using the excel programme to create workbooks. I have 1 work book with lots of xml files in it and it works fine.
My question is where does this workbook store the xml files? The reason I ask is I want to create a new work book using the same xml files. and I don’t want to recreate the same xml file again.
I have followed the instructions on importing xml files in the new workbook and it points me to a folder where there are no xml files stored.
Please help
Bob
Hi Robert,
I guess everything is within own Excel XML schema. You may rename your file Book1.xlsx as Book1.xlsx.zip and unzip it to see what is inside. I'm not sure how to work with the schema, more is for example here https://support.office.com/en-us/article/Overview-of-XML-in-Excel-f11faa7e-63ae-4166-b3ac-c9e9752a7d80
