Home » Questions » Computers [ Ask a new question ]

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: 63
Total answers/comments: 1
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.