If you are attempting to change multiple fields at once, right-click on the
pivot table and got to Pivot Table Wizard, then click on Layout. this will
allow you to change everything at once, then click Finish for the final
product.

If you have any data grouped, ensure all fields still have this data type,
otherwise, youll get ungrouped.

"Matt Cromer" wrote:

I am getting the message regarding too many row or column items. Drag at
least one row or column field off The PivotTable report...

This is a pivot table that I update each week, and this week the error
appeared. I suspect it has less to do with how many columns/rows I have
selected, and more to do with how many combinations are being generated. I
would prefer not to change the pivot table, is there any way around this? I
am using Office Excel 2003 SP3.

Any advice would be appreciated.

Thanks
Matt