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.

I need to use XML file (preferably not local, but pointed by URL) as data source for Excel 2007 pivot table.

But "Use external data source" radio button is disabled on the "Change pivot data source" dialog. What should I do to enable it? Change some security settings or something else?

Thanks!

share|improve this question

1 Answer 1

up vote 1 down vote accepted

Whether or not you can use an external data source is dependant, among other things, on the activecell when you select the pivot wizard. Try a blank, unlocked cell that is not in a table/list.

share|improve this answer
    
I learned what I can select external data source when creating new pivot table, but I once I choosed cell range I can change it to external source no more. –  Alexander Prokofyev Sep 17 '09 at 11:10

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.