|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)
Copyright © 2001 - 2018 MJ Technologies, LLC. All rights reserved.