This documentation is archived and is not being maintained.

PivotTable.PivotFormulas Property (Excel)

Returns a PivotFormulas object that represents the collection of formulas for the specified PivotTable report. Read-only.

expression .PivotFormulas

expression A variable that represents a PivotTable object.

For OLAP data sources, this property returns an empty collection.

For Each pf in ActiveSheet.PivotTables(1).PivotFormulas 
 r = r + 1 
 Cells(r, 1).Value = pf.Formula