PivotFormula PivotFormula PivotFormula Interface


Represents a formula used to calculate results in a PivotTable report.

public interface class PivotFormula
public interface PivotFormula
Public Interface PivotFormula


Use PivotFormulas(index), where index is the formula number or string on the left side of the formula, to return the PivotFormula object.

This object and its associated properties and methods aren’t available for OLAP data sources because calculated fields and items aren’t supported.


_Default _Default _Default

Reserved for internal use.

Application Application Application

Returns an Application object that represents the Microsoft Excel application.

Creator Creator Creator

Returns a 32-bit integer that indicates the application in which this object was created.

Formula Formula Formula

Returns or sets the object's formula in A1-style notation.

Index Index Index

Returns or sets the index number of the object within the PivotFormulas collection.

Parent Parent Parent

Returns the parent object for the specified object.

StandardFormula StandardFormula StandardFormula

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

Value Value Value

The name of the specified formula in the PivotTable formula.


Delete() Delete() Delete()

Deletes the object.

Applies to