PivotTable.ListFormulas Method (Excel)
Creates a list of calculated PivotTable items and fields on a separate worksheet.
Syntax
expression .ListFormulas
expression A variable that represents a PivotTable object.
Remarks
This method isn’t available for OLAP data sources.
Example
This example creates a list of calculated items and fields for the first PivotTable report on worksheet one.
Worksheets(1).PivotTables(1).ListFormulas