PivotFormulas 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.

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

See also:

• Excel Object Model Reference
• PivotFormulas Object Members
• PivotCache Object
• PivotCell Object
• PivotField Object
• PivotFormula Object
• PivotItem Object
• PivotItemList Object
• PivotLayout Object
• PivotTable Object