Pivot Table from VBA or VB6 - Field Settings
 

Is there anyway to control the default Field Settings that the Pivot table
uses?

I have a field that I want the field setting to be an Average but Excel
places it on the sheet as either "Sum of" or "Count of" depending on the
data. Is there anyway to set it to do an Average before hand so that errors
will not pop up?

Currently I'm using an "On Error Resume Next" in order to circumnavigate
this problem.