Edit

Share via

PivotField.ClearValueFilters method (Excel)

  • Article

Calling this method deletes all value filters in the PivotFilters collection of the PivotField.

Syntax

expression.ClearValueFilters

expression A variable that represents a PivotField object.

Remarks

The following list contains the different value filter types that will be deleted by this method:

  • xlTopCount
  • xlBottomCount
  • xlTopPercent
  • xlBottomPercent
  • xlTopSum
  • xlBottomSum
  • xlValueEquals
  • xlValueDoesNotEqual
  • xlValueIsGreaterThan
  • xlValueIsGreaterThanOrEqualTo
  • xlValueIsLessThan
  • xlValueIsLessThanOrEqualTo
  • xlValueIsBetween
  • xlValueIsNotBetween

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.