In 2003, we had a formatting option that would globally remove €œSum Of€� from
the pivot table values. I like that feature. However, I cant seem to find
the same thing in 2007. I can manually change them, but thats no fun,
especially if I have a bunch of values.

Does anyone have solution to this question?

Thanks

Right click in any cell that is subtotaled and uncheck "subtotals"

"Russ" wrote:

In 2003, we had a formatting option that would globally remove €œSum Of€� from
the pivot table values. I like that feature. However, I cant seem to find
the same thing in 2007. I can manually change them, but thats no fun,
especially if I have a bunch of values.

Does anyone have solution to this question?

Thanks

Thanks, but that's not what I'm pursuing. When developing a pivot table, you
will see "Sum of ....." in the pivot table labels. The autoformat
functionality in Excel 2003 provided removed the "sum of" so the user would
just see the label. I.e., "Expenses" versus "Sum of Expenses". This is what
I'm trying to find in 2007.

Thanks again.

Russ

"Eric" wrote:

Right click in any cell that is subtotaled and uncheck "subtotals"

"Russ" wrote:

In 2003, we had a formatting option that would globally remove €œSum Of€� from
the pivot table values. I like that feature. However, I cant seem to find
the same thing in 2007. I can manually change them, but thats no fun,
especially if I have a bunch of values.

Does anyone have solution to this question?

Thanks