Pivot Table Error-"Microsoft cannont make changes because there are too many..."

[Tamara]

I've encountered the following error when using the pivot
table. Microsoft Excel cannot make this change because
there are too many row or column items. Drag at least
one row or column field off the Pivot Table, or to the
page position. Alternatively, right click a field, and
then click Hide or Hide Levels on the shortcut menu.

In the layout tab of the pivot wizard I tried to select 9
rows, 2 columns, and 3 data. The first excel document
that I pivoted had approximately 8800 lines (records) and
the pivot table worked. I then tried to do the same
layout criteria for another excel document that I am
working on that contains approximately 20000 lines
(records) but it won't work...it keeps populating the
error mentioned above.


Thanks

 

[Debra Dalgleish]

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

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

XL2002: Limits of PivotTables in Microsoft Excel 2002
http://support.microsoft.com/default.aspx?id=291061

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