ListFormulas Method

Applies To

PivotTable object.

Description

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

Syntax

expression.ListFormulas

expression Required. An expression that returns a PivotTable object.

Example

This example creates a list of calculated items and fields for PivotTable one.

Worksheets(1).PivotTables(1).ListFormulas