Excel Pivot Table: How to Delete a Calculated Field

To delete a calculated field in an Excel PivotTable, select the PivotTable, then choose PivotTable Analyze > Fields, Items, & Sets > Calculated Field. In the dialog, select the field from the Name list and click Delete. This works for a standard PivotTable; Data Model and OLAP PivotTables use a different calculation system.

Delete a calculated field step by step

Use the desktop Excel app for Microsoft 365 on Windows and make sure you select a cell inside the PivotTable first. The command is contextual, so the PivotTable Analyze tab and its calculation tools may not appear if the active cell is elsewhere.

Click any cell in the PivotTable that contains, or is based on, the calculated field.
Open PivotTable Analyze > Fields, Items, & Sets > Calculated Field. Depending on the ribbon layout, the command may be grouped under Calculations.
In the Insert Calculated Field dialog, open the Name list and select the calculated field you want to remove.
Check the selected name before proceeding, then click Delete. If Excel displays a confirmation, confirm the deletion.
Close the dialog and inspect the PivotTable. If the field still appears in the layout, refresh the PivotTable or remove any remaining display of it from the Values area.

The Delete button removes the calculation definition, not just its current display. If you only want to hide the value temporarily, remove the field from the Values area instead; that keeps the calculated field available to add again later.

What a calculated field is

A calculated field is a custom calculation defined inside a conventional PivotTable. It uses fields from the source data and produces a result that the PivotTable can summarize. For example, a sales report might have source fields named Revenue and Cost, and a calculated field named Profit that subtracts cost from revenue. The calculation is defined in the PivotTable rather than added as a new column to the source worksheet.

That distinction matters when removing one. Deleting the calculated field does not delete Revenue, Cost, or any other source column, and it does not erase the underlying records. It removes the PivotTable calculation and its result from the PivotTable’s field choices. If you need the calculation again, you can recreate it, provided the source fields and the PivotTable type still support calculated fields.

Calculated fields also behave differently from ordinary worksheet formulas. Excel evaluates a PivotTable calculated field in the context of the summarized data; it is not a formula placed in each visible cell of the report. As a result, changing the PivotTable’s rows, columns, or filters can change how the result is summarized. If you need a row-by-row value that becomes part of the source data, a worksheet column or a Power Query transformation may be more suitable.

Remove it from the report or delete it?

There are two different actions that can look similar. Removing a calculated field from the Values area changes what the current PivotTable displays. Deleting the calculated field removes its definition. Choose based on whether you expect to use the calculation again.

Hide it for now: In the PivotTable Fields pane, clear the field’s checkbox or drag it out of the Values area. The calculated field remains available for this PivotTable.
Delete the definition: Use the Calculated Field dialog and its Delete button. The calculation is removed rather than merely hidden.
Remove a source field: Change the source data or its structure only if you intend to affect the data itself. This is not necessary to delete a calculated field.

For example, if you are comparing several versions of a monthly report and want to show Profit only in one version, removing it from the other report’s Values area is usually enough. If the calculation is obsolete and should no longer be offered as a field, delete it. Before doing so, check whether other reports depend on it.

What deletion can affect

PivotTable calculations are associated with the PivotTable’s underlying cache, rather than being ordinary formulas stored in the visible report cells. Workbooks can contain several PivotTables built from the same source and cache. For that reason, treat a calculated field as a shared workbook component: check related PivotTables before deleting it, especially if they were copied from the same report or created from the same source data.

After deletion, review the current PivotTable and any related reports for missing values, changed totals, or layout differences. A PivotChart or another report built around the calculation may also need attention. If the workbook is important, save a separate copy before making a broad change. You can usually recreate the definition, but doing so requires knowing its original name and calculation.

Deleting the field does not rewrite the source workbook or remove records. It does, however, remove the calculation from the PivotTable environment, so undo may not be a reliable recovery plan after you close the dialog or make further changes. Keep a copy or record the calculation details if the original logic is important.

Calculated field versus calculated item

Excel offers both calculated fields and calculated items, and their names are easy to mix up. A calculated field combines or transforms source fields, such as calculating Profit from Revenue and Cost. A calculated item is a custom item within one row or column field—for example, a category created from items in a particular field. They are different features, even though the ribbon groups them under the same Fields, Items, & Sets menu.

If the item you want to remove is a special entry within a row or column label, it may be a calculated item rather than a calculated field. Choose the appropriate option in the Fields, Items, & Sets menu and use the item’s own name and dialog controls. Deleting a calculated field will not necessarily remove a calculated item, and vice versa. Check the field name and where it appears in the PivotTable before making the change.

There is another common source of confusion: a normal source-data column may have a name that looks calculated, such as Margin or Commission. If that column is part of the original table or range, it is not a PivotTable calculated field. The Calculated Field dialog will not delete it; edit the source data if that is what you intend to change.

Why the Calculated Field command may be unavailable

If the menu command is missing, disabled, or the dialog does not list the name you expect, check the PivotTable type and selection before troubleshooting the field itself.

The active cell is outside the PivotTable: Click inside the report so Excel displays the contextual PivotTable Analyze tab.
The PivotTable uses the Data Model or an OLAP source: Traditional calculated fields are not supported in the same way for these PivotTables. They commonly use measures or calculations defined in the model or source instead.
You are looking for a source column: A field imported from the source is not a calculated field, even if its values were calculated in the source worksheet.
The sheet or workbook restricts editing: Check whether the worksheet is protected or the workbook is opened with restricted permissions. You may need the owner’s permission to edit the PivotTable.
The calculation has already been deleted or is in another report: Confirm the selected PivotTable and review the Name list; a workbook may contain multiple PivotTables with different sources or caches.

On Microsoft 365 for Mac, select a cell in the PivotTable and look for the corresponding PivotTable Analyze or Analyze ribbon commands; exact placement can vary by Excel build. Excel for the web has a more limited PivotTable editing experience, so if you cannot find the calculated-field controls, open the workbook in desktop Excel. The same source-type limitation applies: a Data Model or OLAP PivotTable does not become a standard PivotTable simply because you open it on another platform.

Data Model measures need a different approach

A PivotTable built from the Excel Data Model may use a measure rather than a classic calculated field. Measures are calculations defined for the model, often using Data Analysis Expressions (DAX), and they can be used across model-based reports. The standard Calculated Field dialog is not the tool for deleting them.

To remove a measure, use the model’s measure-management tools, such as the Power Pivot window’s measure management options when they are available in your Excel installation. Select the measure in the model and delete it there, then check the PivotTables that use it. The exact controls depend on how the workbook was built and which Power Pivot features are available. If the measure comes from an external OLAP source, its definition may need to be changed in that source rather than in the workbook.

Before deleting a measure, identify all reports that depend on it. A measure can be used in multiple PivotTables, so deleting it can affect more than the report currently selected. If the report only needs to stop showing it, remove it from that PivotTable’s Values area instead of deleting the model measure.

How to recover or replace a deleted field

If you deleted the wrong calculated field, use Undo immediately if it is available and no later action has displaced the undo step. Otherwise, recreate it through PivotTable Analyze > Fields, Items, & Sets > Calculated Field. Enter the original name and rebuild the calculation using the available source fields. Verify the result against a few known records or totals, because a similar-looking formula can behave differently when summarized.

If you do not remember the calculation, look for a saved workbook version, an earlier copy of the report, or documentation from the workbook owner. A calculated field’s displayed values may help identify its purpose, but they are not a dependable substitute for the original definition. Do not assume that changing a source formula will restore a deleted PivotTable calculation automatically; refreshes update data, not the deleted calculation definition.

For a calculation that needs row-level results, consider adding a column to the source Excel table and refreshing the PivotTable. For calculations intended to work across Data Model reports, a measure may be more appropriate. These alternatives serve different purposes, so choose based on whether the calculation belongs to each source record or to the summarized report.

Frequently Asked Questions

Can I delete a calculated field without deleting the PivotTable?
Yes. Deleting the calculated field removes that calculation, not the PivotTable or its source records. The report itself remains, although its layout or displayed values may change if it used the field.

Why can’t I find Calculated Field in Excel?
First click inside the PivotTable and check the PivotTable Analyze tab. If the command remains unavailable, the PivotTable may use the Data Model or an OLAP source, which uses measures or source-defined calculations rather than classic calculated fields.

Does removing a field from Values delete it permanently?
No. Removing it from the Values area only changes the current layout. The calculated field remains available to add again. Use the Calculated Field dialog’s Delete button to remove the definition.

Will deleting a calculated field remove its source data?
No. It does not delete source columns or records. It removes the custom calculation from the PivotTable, while the original source data remains unchanged.

Can I delete a calculated field in Excel for the web?
PivotTable editing features can differ in Excel for the web. If the calculated-field dialog is not available, open the workbook in desktop Excel and use the PivotTable Analyze ribbon. A Data Model or OLAP PivotTable still requires its model or source-specific calculation controls.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.