SlicerCache.SourceType (Excel)

Returns the kind of data source that the slicer is connected to.

xlConsolidation - Multiple consolidation ranges, xlDatabase - Microsoft Excel list or database, xlExternal - Data from another application, xlPivotTable - Same source as another PivotTable report, xlScenario - Data is based on scenarios created using the Scenario Manager.

Only the xlDatabase and xlExternal data source types are supported.

Dim xptSourceType As XlPivotTableSourceType
xptSourceType = ActiveWorkbook.SlicerCaches(1).SourceType
SlicerCache.SourceType procedure builder