Results 1 to 6 of 6
  1. #1
    snax500
    Guest

    Pivot Row Limitations

    In Excel2000, I am trying to add another row to my Pivot table. I keep getting an error message:

    MS Excel cannot make this change because there are too many row or column items.

    I only have 4 row items. Is there any way to work around this without using the page field?

    Thanks<IMG SRC=http://url>

  2. #2
    Lounger
    Join Date
    Oct 2002
    Location
    Mackay, Queensland, Australia
    Posts
    36
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pivot Row Limitations

    Can you give a bit more information? How many fields in total for the pivot table? Excel definitely lets you have more than 4 fields in the "row" position on the table.
    So is it the data that's causing your problem? How many rows of actual data do you have? Have you included a field in the row pozzy of the pivot table that has a squillion unique entries? I have found that the limit is 8016 entries.
    A copy of the file (if it's not confidential) could be useful.

  3. #3
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Silicon Valley, California, USA
    Posts
    273
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pivot Row Limitations

    Make sure that the last row in the spreadsheet doesn't have anything in it. If so, this is a trick you can (or somebody else did) use to prevent people from adding rows to a sheet. Or, somehow something accidentally got typed into the last row, which is also a possibility.

  4. #4
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Baltimore, MD, Maryland, USA
    Posts
    254
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pivot Row Limitations

    Jim:
    You got me confused. To start with I am bad with negatives. So, does making sure "that the last row in the spreadsheet doesn't have anything in it" mean that the last row should be empty? And what does the last row of the data have to do with putting another row in the Pivot Table? The rows of the Pivot Table are the column headers or the fieldnames. Maybe there are so many rows in the data table that including another field will excede the limit of pivot tables to process data.

  5. #5
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Silicon Valley, California, USA
    Posts
    273
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pivot Row Limitations

    Sorry, what I means is:

    Aside from the pivot table, it is possible that there is some entry of some sort (not related at all to the pivot table) in the last possible row of the spreadsheet (65536 for Excel 2000). If this is the case, you won't be able to add rows to the pivot table (or any other section of the spreadsheet), because Excel will try to move the last row down one, but it is already the last possible row (Excel won't allow a row 65537, no matter how hard you try).

    Try this:
    1) End-Down a few times, until you reach row 65536.
    2) Select a few rows, starting at the bottom
    3) Right click the row, choose Delete
    4) Now try adding a row to your pivot table

  6. #6
    New Lounger
    Join Date
    Mar 2001
    Location
    Chicago, Illinois, USA
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pivot Row Limitations

    I too am having a similar problem.
    I have a table that is 21 columns by anywhere between 10 to 400 rows.
    If there are more than 54 records it will generate the error "Microsoft Excel cannot make this change because there are too many row or column items."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •