is there a limit to the # of rows in a pivot table?
sheehanb, from help,
Maximum number of PivotTables on a sheet Limited by available memory
Maximum number of items in a PivotTable 8,000
Maximum number of pages in a PivotTable 8,000
Maximum number of row or column fields in a PivotTable Limited by available
memory
Maximum number of page fields in a PivotTable 256 (May be limited by
available memory)
Maximum number of data fields in a PivotTable 256
Maximum number of calculated item formulas in a PivotTable Limited by
available memory
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
"sheehanb" wrote in message
...
if there is, how can this be increased
|