View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Neil Webber Neil Webber is offline
external usenet poster
 
Posts: 4
Default Pivot table "summarize" default

Whenever I use the "summarize" functionality within a pivot table, the
default setting appears to be "Count". I nearly always want to use "sum".

Is there a way that I can change the default setting to "sum"?

Thanks for your help