|Subject:||Maximum Size Pivot Table|
|Posted by:||Simon Jefford|
|Date:||Sat, 25 Aug 2007|
I have a pivot table set up, reporting on a data table made up of almost
12,000 rows of data. The pivot table has been working fine.
Today I added more data to the data table, now bringing it to 11,990 rows.
However, my Pivot table does pick up data below row 11,923.
I have checked the range for the data in the pivot table and it is set to
pick up data down to row 20,000.
Is there a maximum number of rows of data that you can analyse with a pivot
table or is there another possible reason for this problem ?
Any help, much appreciated.