Excel.PivotField.SourceName.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
PivotField.SourceName property (Excel)	vbaxl10.chm240093	vbaxl10.chm240093	Excel.PivotField.SourceName	d18eb5a0-d44c-9f04-45b1-94cdf468c13e	05/07/2019	medium

PivotField.SourceName property (Excel)

Returns a String value that represents the specified object's name as it appears in the original source data for the specified PivotTable report.

Syntax

expression.SourceName

expression A variable that represents a PivotField object.

Remarks

The value of this property might be different from the current item name if the user renamed the item after creating the PivotTable report.

The following table shows example values of the SourceName 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 names, as shown in the following table.

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

[!includeSupport and feedback]