PivotFormulas Object (Excel)
Collapse the table of content
Expand the table of content
This documentation is archived and is not being maintained.

PivotFormulas Object (Excel)

Represents the collection of formulas for a PivotTable report. Each formula is represented by a 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.

Use the PivotFormulas property to return the PivotFormulas collection. The following example creates a list of PivotTable formulas for the first PivotTable report on the active worksheet.

For Each pf in ActiveSheet.PivotTables(1).PivotFormulas 
 Cells(r, 1).Value = pf.Formula 
 r = r + 1 
Next
Show:
© 2016 Microsoft