External data for pivot table

External data for pivot table I need to use XML file (preferably not local, but pointed by URL) as data source for Excel 2007 pivot table.
Asked by: Guest \| Views: 271

Total answers/comments: 1

Comments display order:

Guest [Entry]

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.