View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Simon Jefford Simon Jefford is offline
external usenet poster
 
Posts: 1
Default Maximum Size Pivot Table

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.
Simon