Pivot Table Issues

Fix Missing PivotTable Fields from an Excel Data Range

Bushra ParveenBushra Parveen Nov 14, 2026 868 views

Question details

The user needs all fields, including calculated columns, to appear in an Excel PivotTable.

Fix Missing PivotTable Fields from an Excel Data Range
Product
Microsoft Excel
Device & OS
not provided
Scenario
A PivotTable is based on a named range or query-backed data that appears to include the required columns.
Observed behavior
Some fields are missing from the PivotTable field list even though their columns appear to be included in the source range.
Before you start

Identify the PivotTable's source range or query and confirm that the missing columns have nonblank, unique headers. If the source is an SQL query, make sure you have access to the connection details and any required credentials.

Solution 1Recommended

Reconnect the Query and Rebuild the PivotTable

Use this approach when the PivotTable is based on an SQL query and its field list remains incomplete.

1
Create a worksheet

Click the plus button next to the worksheet tabs to create a new worksheet.

2
Reconnect the query

Open Data > Queries & Connections, find the SQL query, and use its connection or edit options to reconnect and refresh it. Provide credentials if prompted.

3
Load the query results

In Queries & Connections, right-click the query and choose Load To, then load the results as a table on the new worksheet. Confirm that the missing columns appear in the loaded results.

4
Create a new PivotTable

Select a cell in the loaded table, choose Insert > PivotTable, and create a new PivotTable. Check the field list for the missing columns.

Reconnect the Query and Rebuild the PivotTable
Check the query output: If a column is absent from the loaded query results, inspect the query or its source before rebuilding the PivotTable. Reconnecting alone cannot add a column that the query does not return.
Free Microsoft Office alternative

Work with Spreadsheet Data in WPS Office

WPS Office is a free, lightweight alternative with a familiar interface for working with spreadsheets. Its Microsoft Office format compatibility helps you move existing files into WPS, although it does not repair an Excel query connection or PivotTable metadata.

Open and edit Microsoft Excel XLS and XLSX filesOrganize and analyze spreadsheet data with PivotTable toolsUse a familiar interface that makes migration easierWork with a free, lightweight office suite
QA img-9

Frequently Asked Questions

Why is a calculated column missing from my PivotTable?

The column may be outside the PivotTable source range, missing from the query output, or not reflected in refreshed source metadata. Check Formulas > Name Manager for a named range, then use PivotTable Analyze > Refresh.

How do I check which range my PivotTable uses?

Click inside the PivotTable and select PivotTable Analyze > Change Data Source. For an external connection or Data Model, inspect the associated connection or query instead.

What if the missing field is not in the query results?

Open Data > Queries & Connections and edit the query to check whether it returns the column. Refresh and load the results, then create or refresh the PivotTable.

What should I try if rebuilding the PivotTable does not help?

Check your Excel version and test the workbook or query on another device. Note when the problem began and whether it affects the same fields on both devices.