Excel Pivot Table - Maximum Rows?

[Laura2]

I'm having issues adding more than 8 row items to my excel pivot table. I checked the parameters in help and it said you are only limited by the memory you have. I have tons of available memory however, it errors out when I try to add more than 8 row items. Has anyone encountered this before? I'm calling the data from another sheet in the same workbook.

Thanks,

Laura.

 

[Zelandakh]

I've got pivots running to hundreds of rows. Must have a prob somewhere. version, service pack level, OS, service pack, processor and ram?

 

[KenWright]

You can only have a pivot table display a max of 8,000 items. Besides that limit you are also constrained by the fact that Excel only has 256 columns and 65,536 rows. If by putting in the amount of levels you are trying, you would have to breach either of these (Columns most likely) then you will get an error.

Regards
Ken...............

 

[Laura2]

Excel 2000, not sure on the service pack. Windows 2000. Over 500,000 KB of Ram, Pentium 4.

 

[Laura2]

Thanks Ken. I'm not even close to those limits with my table. It must be something else.

Laura.

 

[Laura2]

This is the error I receive:

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.

I can drag items off but I don't want to do that since I'd like to have 15-18 row items.

Laura.

 

[xlbo]

Zelandakh - row ITEMS not rows. I used to run into this problem as well. It is as Ken says - up to 2000 (I believe - willing to be proved wrong) excel uses a hidden sheet to hold all calculations necessary for the pivot table
The more row items you have, the more calcs that are necessary - you are almost certainly in a position where the calculations will no longer fit on the hidden sheet - either vertically or horizontally. I'm afraid there is no real fix.....

Rgds
Geoff
Si hoc legere scis, nimis eruditionis habes