I'm building a bunch of fairly wide pivot tables, with a couple of
dozen data fields.

When I drag and drop the pivot table data elements into the data
field, Excel appears to choose the count function by default; I would
prefer that it sum by default so that I don't have to manually change
this.

Is there a setting somewhere?

Dave