Edit

Share via

SlicerCache.SourceName property (Excel)

  • Article

Returns the name of the data source that the slicer is connected to. Read-only.

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 that the slicer is based on.

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.