Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Field Settings | Excel Discussion (Misc queries) | |||
Pivot Table field settings default | Excel Discussion (Misc queries) | |||
Pivot table value (field settings) | Excel Discussion (Misc queries) | |||
pivot table field settings % of... | Excel Worksheet Functions | |||
Pivot Table Field Settings | Excel Worksheet Functions |