RE: pivot tables - Limitations!!

Dear Laura

Thank you for attending Excel Advanced course. I hope it was enjoyable as well as beneficial to you!!

Following are the limitations that you need to be aware of when dealing with pivot tables:

Unique items per field

LIMIT: 32,500


Row Field:

A field that's assigned a row orientation in a PivotTable report. Items associated with a row field are displayed as row labels.

Column fields:

A field that's assigned a column orientation in a PivotTable report. Items associated with a column field are displayed as column labels.

LIMIT: Limited by available memory


Page field:

A field that's assigned to a page orientation in a PivotTable or PivotChart report. You can either display a summary of all items in a page field, or display one item at a time, which filters out the data for all other items.

LIMIT: 256 (may be limited by available memory)


Data fields:
This is a field from a source list, table, or database that contains data that is summarized in a PivotTable report or PivotChart report. A data field usually contains numeric data, such as statistics or sales amounts.

LIMIT: 256


Calculated item:
This is an item within a PivotTable field or PivotChart field that uses a formula you create.

LIMIT: Limited by available memory in your computer


If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!


Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003