View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Becky Becky is offline
external usenet poster
 
Posts: 73
Default Pivot Table Default - Count to Sum

When you're using a pivot table, and you pull a field into the pivot, it
defaults to "count". Is there any way to make Excel default to "sum" so that
it doesn't have to be changed every time ? What a pain.