Share via


PivotFormulas Object

Excel Developer Reference

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

Visual Basic for Applications
  For Each pf in ActiveSheet.PivotTables(1).PivotFormulas
    Cells(r, 1).Value = pf.Formula
    r = r + 1
Next

See Also