View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
David David is offline
external usenet poster
 
Posts: 2
Default 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?