I get a error on creating a pivot table saying it has too many rows or columns. What are the limits?
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
I get a error on creating a pivot table saying it has too many rows or columns. What are the limits?
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
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?