dealing with rounding and incorrect totals in pivot tables

Is Excel actually lacking a built-in solution for this, or am I just not aware of it?

I have a pivot table showing summed $ values from my raw data.  The field in my pivot table is formatted to show no decimal places, i.e., values are displayed rounded to the nearest dollar.  The issue is that the total shown in the pivot table, which of course is also rounded to the nearest dollar, may not always match what you get if you add the rounded row values manually.

It's easy to see how this is occurring by simply changing the formatting to show cents, but I'm wondering if there is a good solution.  Of course I could use the ROUND function in my raw data to round all of the values there to the nearest whole dollar before they are summarized in the pivot table, but that is not a good solution because it can increase the total variance.

It seems like Microsoft would have addressed this issue and provided a solution.  After all, if you hand someone a printed report and the grand total shown doesn't actually represent the sum of the values shown on each row, telling them, "it's just because of the way the values are being rounded" does not tend to inspire confidence in your data.

Is there a good workaround for this situation?

Here is an example.

Summarized values shown in my pivot table, formatted to show cents:

115.63

975.01

1,331.63

1,456.25

1,754.38

2,558.37

3,758.38

3,917.51

4,966.63

6,965.75

7,166.63

24,779.26

TOTAL:  59,745.43

Summarized values in my pivot table, formatted to hide cents:

116

975

1,332

1,456

1,754

2,558

3,758

3,918

4,967

6,966

7,167

24,779

TOTAL:  59,745   <-- I would like to see this value as 59,746, since that is what you get if you sum the values above it.

Using Excel 2007 SP2.  Any thoughts?