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