Hi Martin,

The Pivot table autoformat functionality in Excel 2003 would do what I'm
discussing. For example, the autoformat would display "Expenses" versus "Sum
of Expenses". There was 20 autoformats available in addition to Classic and
None.

Try one of these and you'll see what I'm talking about.

Thanks.

Russ

"MartinW" wrote:

Hi Russ,

I don't know which command you mean but maybe one
of these sites might help you out.

http://www.rondebruin.nl/0307commands.htm
http://office.microsoft.com/en-us/he...491511033.aspx

HTH
Martin


"Russ" wrote in message
...
In 2003, we had a formatting option that would globally remove "Sum Of"
from
the pivot table values. I like that feature. However, I can't seem to
find
the same thing in 2007. I can manually change them, but that's no fun,
especially if I have a bunch of values.

Does anyone have solution to this question?

Thanks