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

Can Excel 2007 use an external xml file as the connection for a pivot table? I am able to filter the dialog by xml when specifying a type of data however I get an error saying that it is not a valid datasource.

share|improve this question

After importing the data to a sheet, you can then create a pivot table using the imported data. You can have a pivot table looking directly to an outside source.

share|improve this answer

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.