PivotFilter.Active Property

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

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

public:
 property bool Active { bool get(); };

public bool Active { get; }

Public ReadOnly Property Active As Boolean

Property Value

Boolean

Boolean

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.

Applies to