ListFormulas Method

Microsoft Excel Visual Basic

Creates a list of calculated PivotTable items and fields on a separate worksheet.

expression.ListFormulas

expression    Required. An expression that returns 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