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
