Pivot table limitations.

[Guest]

I would like to remove two critical pivot table limitations, the loading of
pivot table data into RAM and pivot table row items exceeding 32,500, by
running pivot table service on a server and allowing users to page blocks of
rows into RAM from the server. Is there any way to code this or is there a
vendor solution?

Thanks,
Mike Parry
Century Insurance Group

 

[Charles Williams]

You can use pivot table server page fields in Excel, which I think does what
you want.

see
http://support.microsoft.com/default.aspx?scid=kb;en-us;157488&Product=xlw

Pivot tables are designed to provide summaries, so if you really have more
than 35000 unique items in a row field pivot tables are not suitable. (note
you can have millions of rows in a pivot table, its the number of unique
items in a row field, and the Excel memory limits (but 1Gigabyte in
Excel2003) thats the problem).
You could try OLAP cubes instead.


Charles
______________________
Decision Models
FastExcel 2.1 now available
www.DecisionModels.com