+ Reply to Thread
Results 1 to 2 of 2

Pivot Table - too many rows/columns error

  1. #1
    bill_morgan
    Guest

    Pivot Table - too many rows/columns error

    Friends,

    The data I am accessing for my pivot table would comprise only 500 rows if
    Excel would let me put the 5 rows into the Row area, but I get the following
    error message:

    "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."

    Why is Excel giving this error when I am no where near the row or column
    limit of Excel?

    Thanks so much for your help ...

    bill morgan


  2. #2
    bill_morgan
    Guest

    RE: Pivot Table - too many rows/columns error

    "bill_morgan" wrote:
    Believe I found the answer - there is an 8K limit on number of items in a
    pivot table

    > Friends,
    >
    > The data I am accessing for my pivot table would comprise only 500 rows if
    > Excel would let me put the 5 rows into the Row area, but I get the following
    > error message:
    >
    > "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."
    >
    > Why is Excel giving this error when I am no where near the row or column
    > limit of Excel?
    >
    > Thanks so much for your help ...
    >
    > bill morgan
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1