Not
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
This method deletes all label filters or all date filters in the PivotFilters collection of the PivotField.
Syntax
expression.ClearLabelFilters
expression A variable that represents a PivotField object.
Remarks
The following list contains 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 list contains 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
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.