1

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 spreadsheet should act as if it's running an SQL query and update each time that you open the file.

What would be the best way for doing this?

Edit (further information):

Worth noting: Mapped XML Data sources cannot be used in pivot tables. However I would like to use the external xml data source to create pivot tables as well, if this is possible.

Improve this question

1 Answer 1

Reset to default
2

You can use Excel Get External data and specify an XML data source. The data can be set to refresh on a variety of triggers including on file open. Once the data is in Excel, it can be used as the source of a pivot table.

Note I have done some very basic testing done on Excel 2010 to confirm these claims. I think 2007 should work in a similar manner

Improve this answer
2
  • 1
    This is essentially how I would do it also.
    – surfasb
    Dec 23, 2011 at 4:43
  • Appreciated - will look into this further and see how I go
    – Michael A
    Dec 23, 2011 at 7:16

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .