Create a List of Pivot Table Formulas

If you’ve used calculated items and calculated fields in your pivot table, you can automatically create a list of all the formulas.

List the Formulas in Excel 2007

1. Select any cell in the pivot table.
2. On the Ribbon, under the PivotTable Tools tab, click the Options tab.
3. In the Tools group, click Formulas
4. Click  List Formulas.

A new sheet is inserted in the workbook, with a list of the calculated fields and a list of the calculated items.

List the Formulas in Excel 2003

1. Select any cell in the pivot table.
2. On the Pivot toolbar, click PivotTable.
3. Click Formulas, then click  List Formulas.

A new sheet is inserted in the workbook, with a list of the calculated fields and calculated items (see the Excel 2007 example above).

___________________________

For more information on pivot tables, see the Pivot Tables on my Contextures web site.

___________________________