IsCalculated Property

Applies To

PivotField object, PivotItem object.

Description

True if the pivot field or item is a calculated field or item. Read/write Boolean.

Example

This example disables the PivotTable Field dialog box if the PivotTable contains any calculated fields.

set pt = Worksheets(1).PivotTables("Pivot1")
For Each fld in pt.PivotFields
    If fld.IsCalculated Then pt.EnableFieldDialog = False
Next