SourceName Property

Applies To

PivotField Object, PivotItem Object.

Description

Returns the object name (a string) as it appears in the original source data for the PivotTable. This might be different from the current item name if the user renamed the item after creating the PivotTable. Read-only.

Example

This example displays the original name (the name from the source database) of the item that contains the active cell.

Worksheets("Sheet1").Activate
MsgBox("The original item name is " & _
    ActiveCell.PivotItem.SourceName)