Excel Pivot Table Fields Not Showing? How to Fix It

Charts & pivot tables · Updated November 18, 2026

If Excel PivotTable fields are not showing, click inside the PivotTable and select PivotTable Analyze > Show > Field List. If the pane opens but a particular field is missing, check whether the PivotTable’s source range includes that column, then refresh the PivotTable; the field list only reflects fields available in its source.

First, identify what is missing

“Fields not showing” can describe two different problems. The entire Field List pane may be closed, or the pane may be open while one or more expected column names are absent. There is also a third possibility: the field is listed, but you cannot see it in the worksheet because it has not been placed in a layout area.

These situations have different fixes. The pane is a display control; the available fields come from the PivotTable’s data source and cache. The four layout areas at the bottom of the pane—Filters, Columns, Rows, and Values—determine how available fields appear in the report. A field missing from the report is not necessarily missing from the list.

  • No pane at all: reopen the Field List from the PivotTable Analyze tab or the right-click menu.
  • A source column is absent from the list: inspect the source range, headers, and refresh status.
  • A field is listed but not displayed: add it to Rows, Columns, Values, or Filters, as appropriate.

Reopen the PivotTable Field List

In Excel for Microsoft 365 on Windows, select any cell inside the PivotTable. The contextual PivotTable Analyze tab should appear on the ribbon. Choose PivotTable Analyze > Show > Field List. You can also right-click inside the PivotTable and select Show Field List. If the ribbon tab is not visible, first confirm that the selected cell belongs to the PivotTable rather than an adjacent cell.

The Field List is a task pane, so it can be closed independently of the PivotTable. If it is open but narrow, drag its left edge to widen it; a long field name or a list of many source columns may otherwise be difficult to inspect. Look for the pane at the right side of the Excel window, and check whether another workbook window or application is covering it.

On Mac, select the PivotTable and use the PivotTable Analyze tab’s Field List control when it is available; ribbon wording and placement can vary slightly by Excel release. Excel for the web also provides PivotTable field controls, though some features and commands differ from the Windows desktop app. If a command is unavailable in your environment, try opening the workbook in desktop Excel. Hiding the Field List does not delete fields or change the PivotTable’s data.

Check the PivotTable’s source range

A PivotTable can only list fields that exist in its source. If a new column was added after the PivotTable was created, it may sit outside the original range. For example, suppose the source originally occupied A1:D500 and a new Region column was added in E. Refreshing a PivotTable based on A1:D500 will not make Region appear; the source itself must be expanded.

To inspect a standard range-based PivotTable, click inside it and choose PivotTable Analyze > Change Data Source > Change Data Source. Check the range shown in the dialog and make sure it includes the header and all relevant columns. Select the corrected range, confirm the dialog, and refresh. If the source is an Excel Table, the dialog identifies the table; adding data within or directly below a properly formed table is generally easier to maintain than repeatedly editing fixed cell addresses. Check that the table has actually expanded to include the new column.

For a dataset that will grow, consider converting the source range to an Excel Table: select a cell in the data and choose Insert > Table, then confirm that the data has headers. A PivotTable built from that table can use its table name as the source, which is less fragile than a fixed range. Adding a column to the table still may require refreshing the PivotTable before the updated field list appears.

Refresh the PivotTable and its cache

A PivotTable does not always update its displayed field list immediately after the source changes. Right-click inside the PivotTable and choose Refresh, or use Data > Refresh All to update workbook connections and PivotTables. Refreshing is especially relevant after changing source values, adding rows to a table, or updating a connection. However, refresh alone cannot include a column that remains outside a fixed source range.

Excel stores PivotTable data in a cache or obtains it through a connection. That stored structure helps the report work efficiently, but it can make a PivotTable appear out of date until refreshed. If several PivotTables use the same source or cache, a change may affect more than one report; check other PivotTables before assuming the missing field is unique to a single layout.

If the source was replaced or reorganized, verify that the PivotTable still points to the intended range, table, or connection before refreshing. Refreshing a report does not repair a broken external connection or automatically infer that a differently shaped dataset is the new source. For connection-based reports, use the workbook’s connection settings or ask the workbook owner if the connection is managed centrally.

Inspect column headers and source structure

PivotTable fields come from the source’s column headings. Each column should have a clear, nonblank header in the first row of the selected source. Blank, merged, or repeated headings can cause import problems or confusing field names. Excel may assign a generic name to a blank table heading, or it may require you to supply a valid heading before creating or updating the PivotTable. Give every column a distinct, meaningful label, such as Order Date, Product, and Net Sales.

Also check that the source is one continuous rectangular dataset, rather than several separated blocks with blank rows or columns. A blank row between the heading and records, a title row above the actual headings, or a selected range that begins on the wrong row can make Excel interpret the source incorrectly. When you change the source, include the real header row and exclude report titles, totals, and unrelated notes.

A header change can make a field seem to disappear even when the underlying column remains. For example, renaming Customer to Client changes the displayed field name after refresh; it is not necessarily a lost field. Search the list for the new label, and expand any grouped table name if the source is a Data Model with multiple tables.

Make sure the field is not simply outside the visible area

When the Field List is open, use its search box if the source contains many columns. Clear any previous search text before concluding that a field is unavailable. In a multi-table model, expand the relevant table to reveal its columns; the field may be nested under a table heading rather than shown at the top level.

Fields already used in the report can still appear in the available-field list. To display a field, select its checkbox or drag it into one of the four areas at the bottom of the pane. For example, placing Salesperson in Rows and Revenue in Values creates a summary by salesperson. A date field can go in Rows for a time-based breakdown, or in Filters to let a reader filter the entire report.

If the pane is visible but the four areas are missing, look at the lower part of the pane and adjust its height. The field list and layout areas share limited screen space. A field in Values may also be summarized in a way that is not obvious from its label; use the dropdown beside the field in that area to inspect its value-field settings. That affects how a field is calculated in the report, not whether it belongs to the source.

Consider Data Model and connection-based PivotTables

Some PivotTables are built from the workbook Data Model, an external database, or another connection rather than a simple worksheet range. Their fields may be grouped by table, and the model can include calculated measures as well as columns. Expand the table names and inspect the list carefully before treating a field as absent.

A field can also be unavailable because it was not added to the model, was hidden from client tools, or is not exposed by the connection. In those cases, changing a worksheet range will not solve the problem. The model or connection may need to be updated by the workbook author or the person responsible for its data source. Some connection-based PivotTables also restrict changing the source through the usual Change Data Source dialog.

Measures are not ordinary source columns. A measure is a calculation defined in the Data Model and may be displayed differently from a table column. If you expect a calculated measure, ask whether it exists in the model and whether it is exposed to PivotTables. Avoid recreating a measure as a worksheet column without understanding how the original model handles relationships and calculations.

Other common causes and careful checks

Before rebuilding a report, check the simplest explanations. You may be looking at a different PivotTable from the one whose source was changed, or at a worksheet copy that has not been refreshed. A slicer or report filter can hide data items, but ordinarily it does not remove the source field from the Field List. Likewise, hiding a worksheet column does not by itself remove that column from a PivotTable’s source.

If fields still seem missing, make a copy of the workbook before trying structural repairs. Then compare the PivotTable’s current source with the actual data, confirm the header row, and refresh. If the PivotTable uses an external connection or shared Data Model, record the exact missing field and ask the workbook owner to check the connection or model. Deleting and recreating a PivotTable should be a last resort: it can discard layout choices, filters, formatting, and other report settings without fixing the underlying source issue.

Frequently Asked Questions

Why did the PivotTable Field List disappear?
It was likely closed. Click inside the PivotTable, then choose PivotTable Analyze > Show > Field List, or right-click the PivotTable and choose Show Field List.

Why is a new column not appearing after I refresh?
Refresh updates the PivotTable from its defined source, but it may not expand a fixed cell range. Use PivotTable Analyze > Change Data Source to include the column, or verify that the source Excel Table expanded to include it.

Can I add a field to a PivotTable without rebuilding it?
Usually. If the field exists in the source, update the source range if needed, refresh the PivotTable, and then select or drag the field into a layout area. A connection or Data Model may require its owner to update the model instead.

Why is a field missing from the report but visible in the list?
The field has not been placed in a report area, or it is placed in an area that does not display it as expected. Add it to Rows, Columns, Values, or Filters depending on the result you want.

Does hiding a worksheet column remove it from the PivotTable?
No, hiding a worksheet column does not normally remove it from the PivotTable source. Check the selected source range, header, and refresh status instead.

Why does my Data Model field list look different?
Data Model fields are organized by table and can include measures as well as columns. Expand the tables, search for the field, and check with the model owner if it was not included or exposed to PivotTables.

Related

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.