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

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
0
dh00tcj (1)
7/29/2004 6:57:13 PM
excel.misc 78881 articles. 5 followers. Follow

1 Replies
641 Views

Similar Articles

[PageSpeed] 17

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


Tamara wrote:
> 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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

0
dsd1 (5911)
8/1/2004 8:31:34 PM
Reply:

Similar Artilces:

Pivot Table Error-"Microsoft cannont make changes because there are too many..."
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 e...