Skip to content

Files

Latest commit

 

History

History
54 lines (33 loc) · 1.48 KB

Excel.PivotItem.SourceNameStandard.md

File metadata and controls

54 lines (33 loc) · 1.48 KB
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
PivotItem.SourceNameStandard property (Excel)
vbaxl10.chm246093
vbaxl10.chm246093
Excel.PivotItem.SourceNameStandard
f8e25ad0-7a97-c19c-85b5-bf25e3553ca8
05/07/2019
medium

PivotItem.SourceNameStandard property (Excel)

Returns a String that represents the PivotTable items' source name in standard English (United States) format settings. Read-only.

Syntax

expression.SourceNameStandard

expression A variable that represents a PivotItem object.

Remarks

This property is used when an item has a localized version and its SourceNameStandard property value differs from the SourceName property value, such as with date formatting.

Example

This example displays the source name for the sixth item on the fifth field of the active PivotTable. The example assumes that a PivotTable exists on the active worksheet and that the data source contains at least five fields and six items per field.

Sub CheckSourceNameStandard() 
 
 Dim pvtTable As PivotTable 
 Dim pvtField As PivotField 
 Dim pvtItem As PivotItem 
 
 Set pvtTable = ActiveSheet.PivotTables(1) 
 Set pvtField = pvtTable.PivotFields(5) 
 Set pvtItem = pvtField.PivotItems(6) 
 
 ' Display source name. 
 MsgBox "The source name is: " & pvtItem.SourceNameStandard 
 
End Sub

[!includeSupport and feedback]