is there a limit to the # of rows in a pivot table?

P

Paul B

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
 
R

Ron Rosenfeld

if there is, how can this be increased
Click to expand...


I guess you did not check HELP? That would seem to me to be the first place to
go.


PivotTable report specifications

Row or column fields Limited by available memory

Based on that, it would seem logical to suppose that the limit can be increased
by adding memory.



--ron
 
Top