How many items can a pivot table hold? i.e. a worksheet taps out .
 

Does anyone know how much data a pivot table will hold???? I can get it to
accept 30,000 items but not 50,000... What are it's constraints?

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


j wrote:
Does anyone know how much data a pivot table will hold???? I can get it to
accept 30,000 items but not 50,000... What are it's constraints?


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