PivotFormula object (Excel)

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.

Example

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

Methods

• Delete

Properties

• Application
• Creator
• Formula
• Index
• Parent
• StandardFormula
• Value

See also

• Excel Object Model Reference

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.