SlicerCache.ClearManualFilter Method (Excel)
Clears the filtering of all slicers associated with the specified slicer cache.
Version Information
Version Added: Excel 2010
Syntax
expression .ClearManualFilter
expression A variable that represents a SlicerCache object.
Remarks
If you clear filtering from one slicer by using the ClearManualFilter method, but one or more slicers are cross filtering data in that slicer, some items in the first slicer will remain dimmed. For example, if you have a Customer and Country slicer that are cross filtered, and you execute ActiveWorkbook.SlicerCaches("Slicer_Customer").ClearManualFilter, all the items in the Customer slicer will not become available until you execute ActiveWorkbook.SlicerCaches("Slicer_Country").ClearManualFilter. For more information about cross filtering, see the CrossFilterType property.
Example
The following code example clears filtering from all slicers in the active workbook.
Dim cache As SlicerCache
For Each cache In ActiveWorkbook.SlicerCaches
cache.ClearManualFilter
Next cache