Notitie
Voor toegang tot deze pagina is autorisatie vereist. U kunt proberen u aan te melden of de directory te wijzigen.
Voor toegang tot deze pagina is autorisatie vereist. U kunt proberen de mappen te wijzigen.
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.
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.