Excel 2007 : Trouble with MAX on Pivot Tables

[dlefebvre]

I just recently upgraded to Office 2007. One of my workbooks from 2003 is not functioning as it did in 2003, and I don't know why.

I have data that includes 2 labels and a date for each row.

I have a pivot table of that data with the 2 labels as Row Labels and the Max of the Date as the value.

The dates of the second level are correct (the Max date) but the top level is wrong! When I Hide the details of the top, the value is now correct. When I show details again, it is wrong again.

Again, this worked in 2003 but not in 2007. Also, I do have SP1.

I attached the workbook. Please help!

Dan

[dlefebvre]

Have people looked at my workbook? Do you see the same results? Any ideas?

[herbds7]

Confirmed your problem, but no solution.
See your post at Google Groups.