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.

Visual Basic for Applications
Worksheets(1).PivotTables(1).ListFormulas
Create a list of calculated pivottable items and fields on separate sheet? list formulas List Formulas Method ListFormulas ListFormulas Method Procedure for listing calculated pivottable items?

See also: