Excel Tip of the Day

Document a PivotTable's custom calculations and items (Excel 97/2000/2001/2002)

You can create custom calculations and items to enhance the already powerful capabilities provided by a PivotTable. However, if a PivotTable contains many custom calculations or items, it may be difficult to keep track of the formulas behind the scenes that generate the results. Fortunately, it's easy to generate a report that provides details about a PivotTable's custom calculations and items. To do so, click the PivotTable button on the PivotTable toolbar. Then, choose Formulas | List Formulas. Excel adds a new sheet to your workbook that contains the custom calculation and item details.

(Content provided by Element K Journals)

(Note: Your browser is set to refuse cookies. As a result, you may frequently see previously-viewed tips)
PrintPrint CloseClose

Copyright © 2001 - 2018 MJ Technologies, LLC.  All rights reserved.