Pivot Table - too many rows/columns error

G

Guest

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
 
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Question on the occupied field of the pivot table in excel spreadsheet 0
Pivot Table - 3
Can't manipulate pivot table 1
Pivot Table Error-"Microsoft cannont make changes because there are too many..." 1
Error message when using Pivot Table 3
pivot table limitation 1
Pivot Table Limits 2
Limited Pivot Tbl Row and Column Fields 4

Top