MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Pivot tables - "Too many column items"


Posted by rob on June 04, 2001 9:56 AM

What is the max. # of column items in a pivot table? I am trying to display 5 and I get the above message.
Is there any way around this?
I am not displaying any subtotals.

Thanks.


Posted by Mark W. on June 04, 2001 10:30 AM

5 fields or 5 items? If fields, how many items
per field?

Posted by Rob on June 04, 2001 12:11 PM

My apologies.
5 fields. Each field contains between 1 and 6 items. (Most of the fields contain either 1 or 2 items.)
The usefulness of this particular pivot table comes from seeing data on 5 (maybe 6) fields as the page field is changed. These 5 or 6 fields are heirarchical in nature, and really need to be viewed together as column fields.

Posted by Mark W. on June 04, 2001 12:42 PM

Hmmm...

This doesn't seem to be excessive! Have you tried
to create the PivotTable with fewer fields, and
then modify it to include all 5 fields?