View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default Is there a way to turn off Sum on Pivot Tables by default?

If you mean the grand total column, there's no way to hide it by
default. There's an add-in here that you can use to quickly turn the
grand totals on or off:

http://www.contextures.com/xlPivotAddIn02.html

If that's not what you mean, perhaps you can provide an example of what
you're trying to hide.

GHawkins wrote:
I'm running Excel 2003. I create Pivot tables frequently. When I pull in my
data, the "Sum" information appears by deafult. Of course I can go in and
hide this column, but is there a way to hide it by default? I hide it a lot
more than I actually use it.



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html