General discussion


pivot table limitation ?

By highlander718 ·
1500(rows) by 12(columns) original table. I'm trying to create a pivot, one field in columns as soon as I add the 6th in the rows section I get :
"MS Excel cannot create pivot, Too many row or column items". Microsoft knowledgebase only talks about 32.000 or so column item limitation, or some billion items for rows, so I don't think it's the case.
If I split the original table in 4 (about 3-400 rows), it works.

What limitation do I miss ?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by twobordercollies In reply to pivot table limitation ?

Excel allows you to only have 32,500 Unique Items per field.

Row and Column fields are limited by available memory.

Collapse -

by highlander718 In reply to

That I know :-) (as stated in my message). The whole source table is 12*1500=18.000 data fields.

Collapse -

by highlander718 In reply to pivot table limitation ?

This question was closed by the author

Related Discussions

Related Forums