Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
PivotFormula Object (Excel)
Collapse the table of content
Expand the table of content

PivotFormula Object (Excel)

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

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

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
Show:
© 2015 Microsoft