1
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!
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 – 2009-09-17T11:10:56.730