PivotField.StandardFormula (Excel)

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

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.


ActiveCell.PivotField.StandardFormula = "Decimals + 10"