Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question
up vote 2 down vote accepted

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

share|improve this answer
This is essentially how I would do it also. – surfasb Dec 23 '11 at 4:43
Appreciated - will look into this further and see how I go – Codingo Dec 23 '11 at 7:16

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.