StandardFormula Property

Microsoft Excel Visual Basic

expression.StandardFormula

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

Remarks

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.

Example

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