PivotFilter.Active Property
Returns whether the specified PivotFilter() is active. Read-only.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
ReadOnly Property Active As Boolean
Get
'Usage
Dim instance As PivotFilter
Dim value As Boolean
value = instance.Active
bool Active { get; }
Property Value
Type: System.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.