StandardFormula Property [Excel 2003 VBA Language Reference]

Returns or sets a String specifying formulas with standard English (United States) formatting. Read/write.


expression Required. An expression that returns one of the objects in the Applies To list.


The StandardFormula property primarily affects item names with date or number formatting. It provides a way to specify or query a formula for a given calculated item.

The StandardFormula property is "international-friendly" whereas the Formula property is not.


This example adds 10 to the Decimals field and displays it as a calculated item in the data field. The example assumes that a PivotTable exists on the active worksheet and that a field titled "Decimals" exists in the data table.

Sub UseStandardFomula()

    Dim pvtTable As PivotTable
    Set pvtTable = ActiveSheet.PivotTables(1)

    ' Change calculated field of decimals by adding '10'.
    pvtTable.CalculatedFields.Item(1).StandardFormula = "Decimals + 10"

End Sub

Applies to | PivotField Object | PivotFormula Object | PivotItem Object