MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Pivot Table Headaches!


Posted by Tracey on June 27, 2001 5:38 PM

When I try to edit my pivot table ( add a new row) - I keep getting a message that says "Microsoft Excel cannot make this change because there are too many row or column items....."

My original database is relatively modest - 1000 rows by 12 columns, I am trying to create a pivot table with 1 page field, 5 rows, and one data element. - but it won't let me.

I had thought that the maximum number of rows or columns was only limited by available memory - & I am running with 128M of RAM - does anyone else have any ideas?????

Thanks


Posted by J on July 03, 2001 5:45 AM

Your pivot has more columns than the spreadsheet(1000?). Switch your rows and columns.