MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Pivot Table Limits


Posted by Richard on May 31, 2001 3:23 PM

Is there any limit to the information that can be correctly analyzed in a pivot table?


Posted by Mark W. on June 01, 2001 7:59 AM

> 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