PivotField.SourceCaption (Excel)

The SourceCaption property is applicable only for OLAP PivotTables, and returns the original caption from the OLAP server for a PivotField.

You can use the Name or SourceName properties for non-OLAP PivotTables.

Dim strSourceCaption As String
strSourceCaption = ActiveCell.PivotField.SourceCaption