ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot table error (https://www.excelbanter.com/excel-discussion-misc-queries/15680-pivot-table-error.html)

gramos14

Pivot table error
 
I recently starting using Excel 2000 and keep getting the following error
message when adding new fields to the Row section of the table:

"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 the page
position..."

It will allow me to use up to 4 fields in the Row, but not more than 4. I
am able to create the same table in Excel 97 without any problems. My table
is only 500 rows high, so it's well within the limits, but I still get the
error.

Any thoughts?


All times are GMT +1. The time now is 09:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com