Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table undocumented error
Hello all:
Have used simple Pivot Tables for years, never before got this 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 the Pivot Table, or to the page position. Alternately, right click a field, and then click Hide or Hide Levels on the shortcut menu." The source worksheet has 7 fields, 418 records. The fields a STYLE #; DESCRIPTION; COLORS; SIZES; Qty; Price; Ttl. I done other Pivot Tables in exactly the same manner, with no error. I can remove any field and the pivot table works as expected. Any ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
XML error in Pivot Table | Excel Discussion (Misc queries) | |||
Pivot Table Error | Charts and Charting in Excel | |||
Pivot Table #DIV/0! Error | Excel Discussion (Misc queries) | |||
Pivot table error | Excel Worksheet Functions | |||
Pivot table error | Excel Discussion (Misc queries) |