Delete a PivotTable or PivotChart formula

Microsoft Office Excel 2003

previous page next page
  • Determine whether the formula is in a calculated field or a calculated item.

    Calculated fields appear in the PivotTable Field List window. Calculated items appear as items within other fields.

  • Do one of the following:

    ShowDelete a calculated field

    1. Click the report.
    2. On the PivotTable toolbar, click PivotTable or PivotChart, point to Formulas, and then click Calculated Field.
    3. In the Name box, click the field you want to delete.
    4. Click Delete.

    ShowDelete a calculated item

    1. Click the field with the item you want to delete.
    2. On the PivotTable toolbar, click PivotTable or PivotChart, point to Formulas, and then click Calculated Item.
    3. In the Name box, click the item you want to delete.
    4. Click Delete.

    • Note  When you delete a formula from a PivotChart report or its associated PivotTable report, some chart formatting may be lost.

    ShowTip

    If you don't want to delete a formula permanently, you can hide the field or item. To hide a field, drag it out of the report, or click the dropdown arrow in the Data field and then clear its check box; it remains available in the field list. To hide an item, click the dropdown arrow in its field, and then clear the check box for the item.

    previous page start next page