XlSlicerCrossFilterType Enumeration
Specifies the type of cross filtering used by the specified slicer cache and how it is visualized.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Public Enumeration XlSlicerCrossFilterType
'Usage
Dim instance As XlSlicerCrossFilterType
public enum XlSlicerCrossFilterType
Members
| Member name | Description | |
|---|---|---|
| xlSlicerNoCrossFilter | Cross filtering is turned off entirely, so all tiles are displayed and active (not dimmed) regardless of filtering selections in other slicers. | |
| xlSlicerCrossFilterShowItemsWithDataAtTop | Cross filtering is turned on for this slicer cache, any tile with no data for a filtering selection in other slicers connected to the same data source will be dimmed. Additionally, tiles with data are moved to the top in the slicer. (Default) | |
| xlSlicerCrossFilterShowItemsWithNoData | Cross filtering is turned on for this slicer cache, any tile with no data for a filtering selection in other slicers connected to the same data source will be dimmed. |