Skip to content

Latest commit

 

History

History
40 lines (22 loc) · 1.26 KB

Excel.SlicerCache.Name.md

File metadata and controls

40 lines (22 loc) · 1.26 KB
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
SlicerCache.Name property (Excel)
vbaxl10.chm897080
vbaxl10.chm897080
Excel.SlicerCache.Name
3b4a00c0-c6c9-6eee-043c-8102642354df
05/16/2019
medium

SlicerCache.Name property (Excel)

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.

[!includeSupport and feedback]