CalculatedFields Method
Applies To
PivotTable object.
Description
Returns a CalculatedFields collection that represents all the calculated fields in the specified PivotTable. Read-only.
Syntax
expression.CalculatedFields
expression Required. An expression that returns a PivotTable object.
Example
This example prevents the calculated fields from being dragged to the row position.
For Each fld in Worksheets(1).PivotTables("Pivot1").CalculatedFields
fld.DragToRow = False
Next