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

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

Description of the limits of PivotTable reports in Excel
http://support.microsoft.com/default.aspx?id=820742


James wrote:
I need help understanding why when I create certain pivottables using
external data through our SQL server and use just a few fields that MS
provides an error stating that my pivottable is too big and that I've exceed
65,536 "items". Here is the catch, I know for a fact that data-wise, that I
won't consume more that 10,000 lines. Is there some hidden placeholders
shall we call them that causes my pivottable to be larger than it appears?
Knowing there is a 65536 line limit is there any work around without going to
Access? Thanks in advance!


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