Pivot table field is missing rows/does not update

Question

Good Afternoon,

I changed the column title of source data. Now it doesn't show in the field rows even though I refreshed it. Thanks for your help

Source(new)

Pivot table still show the old Column title.

None appeared on the rows.

Answer 1

Hi Kay-L ,

Oh no apologies, for some reason it bounced back few times.  It worked when I replied to your email yesterday.

Therence

Regards,

Answer 2

Dear Therence,

My apologies for the late response.

Since you've already covered the standard troubleshooting, this points to a more subtle issue, most likely with the structure of your source data itself. Let's focus on what might be preventing Excel from recognizing that column header update, and how to make your PivotTable setup more robust.

The Most Common Underlying Problem (Even After Source Verification):

Merged Cells in the Header Row:

• This is a very frequent culprit for PivotTable header recognition issues. If you have any merged cells in the very first row of your source data (where your column titles are), Excel's PivotTable engine can struggle to correctly identify and update individual column headers.
• Go to your source data sheet. Select the entire first row that contains your headers. On the "Home" tab, in the "Alignment" group, click the "Merge & Center" button. If it's highlighted, click it again to unmerge any cells. Ensure each header is in its own, unmerged cell.

Making Your Source Data Robust:

Convert Your Source Data to an Excel Table:

This is hands-down the best way to manage source data for PivotTables, as it dynamically updates ranges and headers. If your source data isn't already an official Excel Table, this is a highly recommended modification.

• Go to your source data sheet.
• Click anywhere within your data range (including the headers).
• Go to the "Insert" tab on the Ribbon.
• Click "Table" (or press Ctrl + T).
• In the "Create Table" dialog box, ensure "My table has headers" is checked. Click "OK".
• Once your data is in an Excel Table (e.g., named "Table1"), the PivotTable automatically uses the table's name as its source, and it will automatically pick up new columns and updated headers when you refresh. You won't need to manually adjust the range or worry about it again.

After Making Source Data Changes (Especially to an Excel Table):

1. Verify PivotTable Data Source (again):
   • Click anywhere in your PivotTable.
   • Go to "PivotTable Analyze" (or "Analyze") tab.
   • In the "Data" group, click "Change Data Source".
   • Make sure the source is now referencing your Excel Table name (e.g., Table1) instead of a static range. Click "OK".
2. Perform a Full Refresh (again):
   • Go to the "Data" tab on the Ribbon.
   • Click the "Refresh All" dropdown, and then select "Refresh All".

Please give these a try. Let me know if fixing merged cells or converting your source data to an Excel Table resolves this persistent problem!

Kind regards,

Kai-L - MSFT | Microsoft Community Support Specialist

Answer 3

From: Therence Valdez Sent: June 30, 2025 10:40 AM
To: MicrosoftAnswers@microsoft.com
Subject: RE: Question has a reply: Pivot table field is missing rows/does not update

Good morning Kai-L,

My response was undelivered.

I have tried 1-5. It did not work.  I am hoping I don’t have to re-create the pivot table each time reporting comes.

I wonder if there’s a faster way to recreate it / or to copy the pivot table fields/settings? or is anything that I need to modify the source table?

Thank you for your response.

Regards,

Therence

Answer 4

Dear Therence,

Just checking in to see if the above information was helpful. If you have any further updates on this issue, please feel free to post back.

Answer 5

Dear Therence,

Thank you for posting in Microsoft Community.

I understand you're encountering an issue with your Excel PivotTable where, after changing column titles in your source data, the PivotTable Fields pane is not updating to show the new titles, and these fields are not appearing as expected in the Rows area. I can see from your screenshots that the PivotTable is still displaying the old column titles (e.g., "Expected date of Arrival (20MAY2025)") even though your source data shows the new ones (e.g., "Expected date of Arrival (25APR2025)"). This is a common situation, and it's usually due to the PivotTable's connection to its source data.

Here are some steps you can take to fix it:

1. Verify and Update the PivotTable's Data Source Range

This is the most frequent cause. If you've added new columns or moved existing data, the PivotTable's defined data source might not include these changes.

• Go to your PivotTable.
• Click anywhere inside the PivotTable to make the "PivotTable Analyze" (or "Analyze" or "Options") tab appear on the Ribbon.
• In the "Data" group, click "Change Data Source".
• In the "Change PivotTable Data Source" dialog box, carefully verify that the selected range (or table name) encompasses all your new and updated column headers, and all the data you wish to include.
  • If you're using a structured Excel Table (e.g., Table1 ), ensure the new columns are part of that table. If you simply typed headers next to an existing table, they might not be part of it.
  • If you're using a range (e.g., Sheet1!$A$1:$Z$100), manually adjust the range to include any new columns or rows.
• Click "OK".

2. Perform a Full Refresh

While you mentioned refreshing, it's worth trying a comprehensive refresh.

• After updating the data source (or even if you believe it's correct), go to the "Data" tab on the Ribbon.
• Click the "Refresh All" dropdown, and then select "Refresh All". This ensures all data connections and PivotTables in the workbook are updated.

3. Check for Data Model Usage

If your PivotTable is based on Excel's Data Model (often used when importing multiple tables or using Power Pivot), changes might need to be managed there.

• Click anywhere inside the PivotTable.
• Go to the "PivotTable Analyze" (or "Analyze") tab.
• In the "Data" group, look for "Connections" or "Data Model" options.
• If your PivotTable uses the Data Model, you might need to go to the Power Pivot window (if enabled, often under the "Power Pivot" tab) and ensure the columns are correctly updated/refreshed within the Data Model itself.

4. Ensure Headers are in the Data Range

Confirm that your new column titles are in the first row of your data source range that the PivotTable is using. PivotTables rely on these headers to populate the field list.

5. Clear PivotTable Cache (Last Resort)

Sometimes, the PivotTable's internal cache gets stuck. You can't directly "clear" it, but you can force it to rebuild by making a minor change to its properties.

• Right-click on your PivotTable and select "PivotTable Options...".
• Go to the "Data" tab.
• Under "Number of items to retain per field:", try changing it from "Automatic" to a specific number (e.g., 1000) or vice-versa, then change it back. This can sometimes force a cache refresh.
• Alternatively, and more reliably, if all else fails, you may need to recreate the PivotTable. This builds a fresh cache from the updated source data.

If none of the above solutions work, let me know for further investigation. Please note that our initial response does not always resolve the issue immediately. However, with your help and more detailed information, we can work together to find a solution.
Kind regards,

Kai-L - MSFT | Microsoft Community Support Specialist