PivotFilter.Active Property (Excel)
Returns whether the specified PivotFilter is active. Read-only Boolean .
expression A variable that represents a PivotFilter object.
This property returns True when the PivotField of the filter is in the PivotTable and the filter is evaluated when the PivotTable is updated. It returns False when the PivotField of the filter is not in the PivotTable and has no effect on the PivotTable calculation.