MrExcel Publishing
Your One Stop for Excel Tips & Solutions

limit of pivot table

Posted by Anthony on July 19, 2001 10:16 AM

I have a worksheet I set up a pivot table for, it has 500 rows and 14 columns when I try to put 4 items in the pivot table row I get “ Microsoft excel cannot make this change because there are too many row or column items”. In the help file it said the maximum number of items is 8,000 is an item a cell a word or letter? It also said the number of rows and column is limited by memory, I have 64MB of ram but 2 GB on the hard drive, I think windows use the hard drive for memory when the ram is full, is this right? Thanks for any help.

Posted by Mark W. on July 19, 2001 10:20 AM

See the Excel Help topic for "Parts of a PivotTable".
Items are in yellow.