Fix Missing PivotTable Fields from an Excel Data Range
Question details
The user needs all fields, including calculated columns, to appear in an Excel PivotTable.

- 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.
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.
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.
Click the plus button next to the worksheet tabs to create a new worksheet.
Open Data > Queries & Connections, find the SQL query, and use its connection or edit options to reconnect and refresh it. Provide credentials if prompted.
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.
Select a cell in the loaded table, choose Insert > PivotTable, and create a new PivotTable. Check the field list for the missing columns.

Check the Source Range and Refresh the PivotTable
Use this approach first when the PivotTable uses a worksheet range or named range.
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.

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.




