Maximum Size Pivot Table

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

Replies