Sleeper: Pivot Table Too Large

[stapuff]

I get a error on creating a pivot table saying it has too many rows or columns. What are the limits?:banghead:

I have 4 columns and 1500 rows. I would like to add another column. Is there a certian number of cells a pivot can handle?

Thanks,

Kurt

[Norie]

Kurt

What are you trying to add as row/column items?

I think there is a limit to the no of columns in a pivot table. I think the no of columns in a pivot table is determined by how many different categories you have in your column item.

Perhaps you could post some sample data?