SlicerItem.HasData Property (Excel)
Returns whether the slicer item contains data that matches the current manual filter state. Read-only.
Version Information
Version Added: Excel 2010
Syntax
expression .HasData
expression A variable that represents a SlicerItem object.
Return Value
Boolean
Remarks
True if the slicer item contains data that matches the current manual filter state; otherwise False.
This property is only supported when cross filtering is turned on, and will generate a run-time error otherwise. To determine if cross filtering is turned on for a slicer associated with a PivotTable report, check the value of the CrossFilterType property of the specified SlicerItem object's parent SlicerCache object. To determine if cross filtering is turned on for a slicer associated with an OLAP data source, check the value of the CrossFilterType property of the SlicerCacheLevel object that corresponds to the OLAP hierarchy being filtered.