Excel.PivotItem.Name.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
PivotItem.Name property (Excel)	vbaxl10.chm246078	vbaxl10.chm246078	Excel.PivotItem.Name	b3861675-1f05-9e0d-442c-1cd95385ca09	05/07/2019	medium

PivotItem.Name property (Excel)

Returns or sets a String value representing the name of the object.

Syntax

expression.Name

expression A variable that represents a PivotItem object.

Remarks

The following table shows example values of the Name property and related properties given an OLAP data source with the unique name "[Europe].[France].[Paris]" and a non-OLAP data source with the item name "Paris".

Property	Value (OLAP data source)	Value (non-OLAP data source)
Caption	Paris	Paris
Name	[Europe].[France].[Paris]  (read-only)	Paris
SourceName	[Europe].[France].[Paris]  (read-only)	Same as the SQL property value (read-only)
Value	[Europe].[France].[Paris]  (read-only)	Paris

When specifying an index into the PivotItems collection, you can use the syntax shown in the following table.

Syntax (OLAP data source)	Syntax (non-OLAP data source)
expression.PivotItems("[Europe].[France].[Paris]")	expression.PivotItems("Paris")

When using the Item property to reference a specific member of a collection, you can use the text index name as shown in the following table.

Name (OLAP data source)	Name (non-OLAP data source)
[Europe].[France].[Paris]	Paris

[!includeSupport and feedback]