Edit

Share via

SlicerCache.Name property (Excel)

  • Article

Returns or sets the name of the slicer cache.

Syntax

expression.Name

expression A variable that returns a SlicerCache object.

Return value

String

Remarks

The name of the slicer cache must be unique within the workbook namespace. By default, the name assigned to a slicer cache is Slicer_ followed by the name of the PivotTable field that the slicer cache is associated with.

For example, if slicer is associated with the Product Category field in the PivotTable, the default name will be Slicer_Product_Category (any spaces in the field name are replaced with underscore characters). If there is more than one Product Category field in the same workbook with a slicer associated with it, or some other named entity in the workbook with the name Slicer_Product_Category, Excel appends a number after the name to produce a unique name, such as Slicer_Product_Category1.

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.