Share via


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

See Also

Concepts

PivotTable Object

PivotTable Object Members