SlicerCache.SourceName Property (Excel)
Returns the name of the data source the slicer is connected to. Read-only
Version Information
Version Added: Excel 2010
Syntax
expression .SourceName
expression A variable that represents a SlicerCache object.
Return Value
String
Remarks
For slicers based on data in the workbook (SlicerCache.SourceType = xlDatabase), or slicers based on non-OLAP external data (SlicerCache.SourceType = xlExternal and SlicerCache.OLAP = False), returns the name of the corresponding column in the source data.
For OLAP slicers (SlicerCache.OLAP = True), returns the MDX unique name of the hierarchy the slicer is based on.