PivotFormula Object [Excel 2003 VBA Language Reference]

  • Article
PivotFormulas
PivotFormula

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

Remarks

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

Using the PivotFormula Object

Use PivotFormulas(index), where index is the formula number or string on the left side of the formula, to return the PivotFormula object. The following example changes the index number for formula one in the first PivotTable report on the first worksheet so that this formula will be solved after formula two.

Worksheets(1).PivotTables(1).PivotFormulas(1).Index = 2

Properties | Application Property | Creator Property | Formula Property | Index Property | Parent Property | StandardFormula Property | Value Property

Methods | Delete Method

Parent Objects

Child Objects

See Also | PivotCache Object | PivotCell Object | PivotField Object | PivotItem Object | PivotItemList Collection | PivotLayout Object | PivotTable Object