PivotField.IsCalculated (Excel)

True if the PivotTable field is a calculated field or item.

For OLAP data sources, this property always returns False.

Dim booIsCalculated As Boolean
booIsCalculated = ActiveCell.PivotField.IsCalculated