Syntax

expression.CalculatedFields

expression A variable that represents a PivotTable object.

Return Value
CalculatedFields

Example

This example prevents the calculated fields from being dragged to the row position.

Visual Basic for Applications 
For Each fld in _ Worksheets(1).PivotTables("Pivot1") _ .CalculatedFields fld.DragToRow = False Next
calculated calculated fields Calculated Fields Method CalculatedField calculatedfield method calculatedfields calculatedfields method list all calculated fields reference every calculated field return collection all calculated fields pivot table

See also: