I have a pivottable that worked just fine in Excel 2003, but Excel 2007
doesn't handle correctly.
I grouped a few items in the column area, but when a hide details/collapse
the group, Excel 2007 still leaves it in multiple columns, with up to 1
column for each row in the table.

Be blessed

Haffi:
I thought I was the only person having this problem. In my case it also
seems to effect the PivotTable's results.

I'm going to try reloading Excel to see if that fixes the problem.

Mike


"Haffi" wrote:

I have a pivottable that worked just fine in Excel 2003, but Excel 2007
doesn't handle correctly.
I grouped a few items in the column area, but when a hide details/collapse
the group, Excel 2007 still leaves it in multiple columns, with up to 1
column for each row in the table.

Be blessed