Share via


PivotField.ClearLabelFilters Method

Excel Developer Reference

This method deletes all label filters or all date filters in the PivotFilters collection of the PivotField.

Version Information
 Version Added:  Excel 2007

Syntax

expression.ClearLabelFilters

expression   A variable that represents a PivotField object.

Bb242094.vs_note(en-us,office.12).gif  Note
Currently, supports only one label or date filter per field at any given time, but this restriction might be lifted in the future.

Remarks

The following table lists the different label filter types that will be deleted by this method.

xlCaptionEquals
xlCaptionDoesNotEqual
xlCaptionIsGreaterThan
xlCaptionIsGreaterThanOrEqualTo
xlCaptionIsLessThan
xlCaptionIsLessThanOrEqualTo
xlCaptionBeginsWith
xlCaptionDoesNotBeginWith
xlCaptionEndsWith
xlCaptionDoesNotEndWith
xlCaptionContains
xlCaptionDoesNotContain
xlCaptionIsBetween
xlCaptionIsNotBetween

The following table lists the different date filter types that will be deleted by this method.

xlSpecificDate
xlNotSpecificDate
xlBefore
xlBeforeOrEqualTo
xlAfter
xlAfterOrEqualTo
xlDateBetween
xlDateNotBetween
xlDateToday
xlDateYesterday
xlDateTomorrow
xlDateThisWeek
xlDateLastWeek
xlDateNextWeek
xlDateThisMonth
xlDateLastMonth
xlDateNextMonth
xlDateThisQuarter
xlDateLastQuarter
xlDateNextQuarter
xlDateThisYear
xlDateLastYear
xlDateNextYear
xlYearToDate
xlAllDatesInPeriodQuarter1
xlAllDatesInPeriodQuarter2
xlAllDatesInPeriodQuarter3
xlAllDatesInPeriodQuarter4
xlAllDatesInPeriodJanuary
xlAllDatesInPeriodFebruary
xlAllDatesInPeriodMarch
xlAllDatesInPeriodApril
xlAllDatesInPeriodMay
xlAllDatesInPeriodJune
xlAllDatesInPeriodJuly
xlAllDatesInPeriodAugust
xlAllDatesInPeriodSeptember
xlAllDatesInPeriodOctober
xlAllDatesInPeriodNovember
xlAllDatesInPeriodDecember

See Also