The following MSKB articles outline PivotTable limitations for different
versions of Excel:

XL2000: Limits of PivotTables in Microsoft Excel 2000
http://support.microsoft.com/default.aspx?id=211517

Limits of PivotTable Reports in Microsoft Excel 2003
http://support.microsoft.com/default.aspx?id=820742



dmotika wrote:
Hi! What is the maximum rows allowed in a data range when using a pivot table?

I have a pivot table that uses a data range. When I have only 4581 records
in the data range, the pivot table updates with no problems. But, when
entering more than 4581, the pivot table won't update and gives me an error.

Am I hitting the max on data rows within my data range or is there a
work-around.

Thanks!!

dmotika



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html