| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Error message when using Pivot Table | Excel Discussion (Misc queries) | |||
| Pivot Table - Multiple consolidation Range | Excel Worksheet Functions | |||
| Pivot table error | Excel Discussion (Misc queries) | |||
| Removing errors from a Pivot table | Excel Discussion (Misc queries) | |||
| Hide Pivot Table Divide by 0 error | Excel Worksheet Functions | |||
Linear Mode
