Skip to content

Latest commit

 

History

History
29 lines (12 loc) · 702 Bytes

9fdbab3b-96e1-d821-5dc3-77a8a02c850a.md

File metadata and controls

29 lines (12 loc) · 702 Bytes

PivotFilter.Active Property (Excel)

Returns whether the specified PivotFilter is active. Read-only Boolean .

Syntax

expression . Active

expression A variable that represents a PivotFilter object.

Remarks

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.

See also

Concepts

PivotFilter Object

Other resources

PivotFilter Object Members