XML and PivotTables on Excel 2003

  • Thread starter Michael Wrighton
  • Start date
M

Michael Wrighton

Hi,
I've got an enormous XML file I'm attempting analyze
through pivot tables. For small versions of the file, I
can load the whole thing into the worksheet, and
construct a Pivot table from the list. But I have a file
that is large enough to go far beyond the worksheet size
limitations in Excel (64K rows).

I've tried loading my XML into Access, but that doesn't
seem to give me anything meaningful. (It seems to remove
the hierarchy from the XML). I'd like an "XML Datasource"
option to Pivot table, but that doesn't seem to be
available.

Can anyone give me a hand?

Thanks,
-michael
 
Top