PivotTable.CalculatedFields Method

Returns a CalculatedFields collection that represents all the calculated fields in the specified PivotTable report. Read-only.

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.

  For Each fld in _
        Worksheets(1).PivotTables("Pivot1") _
        .CalculatedFields
    fld.DragToRow = False
Next

See Also

• PivotTable Object
• PivotTable Members