Programmatically Modify Pivot Table Fields?

[SteveM]

I'm trying to figure out how to custom modify calculated fields in
Pivot Tables. I have two linked questions.

First: I have Pivot Table Forms which do not present a Design tab when
I open them. So I cannot modify them using the Ribbon functions. Why
is that? Is there a way to activate the Design tab for Pivot Table
Forms?

Second: Even with Pivot Tables with the Design function still
accessible, the associated Property Sheet only allows for limited
formatting mods. For example, I have a Pivot Table of averaged field
values with a Fixed format of 2 decimal places. I want integers
only. But I cannot adjust the decimal places via the dialog box. So
is there a way to do it with code? Are the embedded objects inside of
a Pivot Table Form accessible via VBA?

Thanks Much,

SteveM

 

[SteveM]

I'm trying to figure out how to custom modify calculated fields inPivotTables.  I have two linked questions.

First: I havePivotTable Forms which do not present a Design tab when
I open them.  So I cannot modify them using the Ribbon functions.  Why
is that?  Is there a way to activate the Design tab forPivotTable
Forms?

Second: Even withPivotTables with the Design function still
accessible, the associated Property Sheet only allows for limited
formatting mods.  For example, I have aPivotTable of averaged field
values with a Fixed format of 2 decimal places.  I want integers
only.  But I cannot adjust the decimal places via the dialog box.  So
is there a way to do it with code?  Are the embedded objects inside of
aPivotTable Form accessible via VBA?

Thanks Much,

SteveM

Surfacing this back to the top of the queue. Again, any advice on how
to format pivot tables programmatically would be appreciated.

SteveM