PivotFormula Object

Remarks

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

Example

Use PivotFormulas(), where is the formula number or string on the left side of the formula, to return the PivotFormulaobject. 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

See also:

• Excel Object Model Reference
• PivotFormula Object Members
• PivotCache Object
• PivotCell Object
• PivotField Object
• PivotItem Object
• PivotItemList Object
• PivotLayout Object
• PivotTable Object