A pivot table in Excel won't allow me to add more fields or move a field from
the column area to the row area. When I drag a new field or attempt to move
the field, the Excel status bar displays the progress bar and a message
"calculating pivot table report" but after about 1 or 2 seconds, it stops
w/out an error message.

The pivot table is based on an Access db table, which has 177,000 records
and 11 fields. The pt field list displays 10 of those fields. The table
itself only uses 4.

The workbook is about 12 mb, and when I query the cache.usedMemory property,
it returns 22,004,989 (I assume bytes).

I'm using Excel 2003 w/ SP2.

Has anyone experienced this problem before? Is there a solution?

Thanks,

gt