3
votes
1answer
87 views

Is it possible to edit the source representation of objects in Excel?

I often find myself copying and pasting worksheets in order to show the same analysis for different sets of data. This includes graphs. It's irritating having to 'select data' for every data series, ...
1
vote
1answer
351 views

Microsoft Office Data Connection to utilise an external XML Data source?

I want to be able to process or product for connecting an external XML data connector to Microsoft Office Products (specifically Excel) so that it's seamless to the product. Essentially the ...
0
votes
4answers
3k views

Excel 2007 user warning when opening xls files

I am getting the following error warning when opening an .xls file generated using 'CarlosAg.ExcelXmlWriter.dll' in Excel 2007: The file you are trying to open,'', is in a different format than ...
5
votes
3answers
7k views

Excel: Edit the XML inside an XLSX file

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+ ...