PivotFilters Object (Excel)

The PivotFilters object is a collection of PivotFilter objects.

Version Information

Version Added: Excel 2007


The PivotFilters collection contains properties and methods to add new filters, count the number of existing filters in the collection, and reference specific PivotFilter objects.


In the following example, a new PivotFilter is added to the PivotField at the currently active cell.

ActiveCell.PivotField.PivotFilters.Add FilterType := xlThisWeek

See Also


Excel Object Model Reference

PivotFilters Object Members