Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

1 Answer 1

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

 
discard

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.