Excel Pivot Table Won’t Refresh? How to Fix It

Charts & pivot tables · Updated November 18, 2026

If an Excel PivotTable won’t refresh, select a cell inside it and choose PivotTable Analyze > Refresh in Excel for Microsoft 365 on Windows, or use Data > Refresh All to update all workbook connections and PivotTables. If the figures still do not change, check that the PivotTable points to the right source range, that the source itself has updated, and that filters or cached items are not hiding the expected results.

Try a refresh, then confirm what changed

Start with the simplest refresh before changing the PivotTable’s structure. Click inside the PivotTable so its contextual ribbon tab appears, then select PivotTable Analyze > Refresh. You can also right-click a PivotTable cell and choose Refresh. On Windows, Alt+F5 refreshes the selected PivotTable; Ctrl+Alt+F5 refreshes all data connections and PivotTables in the workbook.

After refreshing, compare a recognizable source record with the PivotTable. If a new sale, date, or category is missing, search for that exact value in the source data. This separates two different problems: Excel may not be reading the updated source, or it may be reading it but the PivotTable’s layout and filters are not displaying the record. If the PivotTable is based on an external connection or a query, use Data > Refresh All and allow the connection time to finish.

On a Mac, select the PivotTable and use the refresh command on the contextual PivotTable ribbon tab, or use Data > Refresh All where available. Ribbon labels and placement can vary slightly by Excel release. Excel for the web has fewer options for some external connections, so a workbook that relies on a desktop-only connection may need to be refreshed in the desktop app.

How PivotTable refresh works

A PivotTable summarizes records from a source, such as a worksheet range, an Excel table, a database connection, or the Excel Data Model. Refresh tells Excel to read that source again and update the PivotTable’s summary. It does not necessarily change the source itself. For example, refreshing a PivotTable based on a Power Query result does not fix a query that failed to load or still points to an old file.

Many PivotTables use a cache: stored data and field information that Excel uses to build the summary. Refresh updates the PivotTable from its source and cache, but it does not automatically correct a bad source selection, a broken connection, or a filter that excludes the records you want. This is why “Refresh” can complete without an obvious error while the displayed result looks unchanged.

A refresh can also take time. Large sources, remote files, databases, and several connected tables may need to finish processing before the PivotTable changes. Wait for Excel to complete the operation, and check for a connection message or prompt rather than repeatedly clicking Refresh. If the workbook has several queries, Data > Queries & Connections can help identify whether a query is still running or has returned an error.

Check whether the source range includes new rows

A common cause is that the PivotTable was created from a fixed cell range. Suppose the original source was A1:D500, but new records were added in rows 501 through 520. Refreshing the PivotTable will not necessarily include those rows if its source still ends at row 500. Confirm the source by clicking the PivotTable and choosing PivotTable Analyze > Change Data Source. Inspect the selected range and correct it if it excludes the new records.

For a changing list, an Excel table is usually easier to maintain than a fixed range. Select a cell in the source list and choose Insert > Table (or press Ctrl+T on Windows), confirm that the table has headers if it does, and then base the PivotTable on that table. When you add records directly below an Excel table, the table expands to include them. Refresh the PivotTable afterward to bring the added records into the summary. On Mac, Command+T is the usual shortcut for creating a table.

Check the source’s shape as well as its last row. Each column should have a header, and a source column should not contain a blank header or multiple header rows. A pasted report may also include a total row, blank lines, or notes inside the records. Those are source-data issues, not refresh failures, and can create unexpected fields or summaries. If you change the source columns, refresh and confirm that the PivotTable field list reflects the intended headers.

Look for filters, grouping, and layout choices

A record can be present in the source and still be absent from view. Check the filter arrows beside row and column labels, any report filter above the PivotTable, and slicers or timelines connected to it. A filter may be set to one region, month, or product, making new records from other categories invisible. Use the filter menu to clear the relevant filter or select the missing item. Also check whether a slicer is affecting more than one PivotTable.

Grouping can make dates and numbers appear different from the raw records. A date field grouped by month may show a new date under an existing month rather than as a separate line. If the source contains text that looks like a date, Excel may not group it as expected. Inspect the source values and the PivotTable field layout before assuming the refresh failed. Similarly, a field placed in the Filters area will not appear as a row in the main body of the PivotTable.

When totals seem wrong, check the value-field calculation. A field containing numbers may be summarized by count rather than sum, particularly if Excel interprets some entries as text. Right-click a value and choose Summarize Values By to see or change the calculation. Refresh updates the values it reads; it does not guarantee that the selected summary type matches the question you want the PivotTable to answer.

Deal with old labels and cached items

Sometimes a PivotTable continues to show a category that has been deleted from the source. That does not always mean the source still contains the record: Excel may retain old field items in the PivotTable cache so they remain available in filters. To clear retained items, right-click inside the PivotTable and choose PivotTable Options. On the Data tab, set Number of items to retain per field to None, then refresh the PivotTable.

This setting addresses old labels, not missing current records. If a current category is absent, verify the source range, the spelling and spaces in the source values, and any active filters. For example, “North” and “North ” (with a trailing space) can be treated as separate text items. Cleaning inconsistent source labels can prevent confusing duplicate categories after refresh.

If a field was renamed or removed, the field list may not match what you expect until Excel rereads the source. Refresh after confirming the source headers. Avoid deleting and rebuilding the PivotTable as the first response: rebuilding can discard its layout, formatting, filters, and calculated items. First correct the source or cache setting and see whether a normal refresh resolves the discrepancy.

Refresh queries and external connections

When a PivotTable uses data from Power Query, a database, a text file, or another workbook, there may be more than one refresh step. First make sure the query or connection can retrieve current data; then refresh the PivotTable that summarizes it. Data > Refresh All is a useful first choice because it requests updates for workbook connections as well as PivotTables. If the result is still old, open Data > Queries & Connections and inspect the relevant query or connection for an error.

External sources can fail because a file was moved, a server is unavailable, a sign-in is required, or access permissions have changed. Excel may display a credential or connection prompt. Resolve that prompt using the correct access method for the source; do not assume the PivotTable itself is defective. If a query loads its result to a worksheet table, verify that the query output has changed before diagnosing the PivotTable. A PivotTable cannot summarize new records that the upstream query did not deliver.

Also check whether the workbook is set to refresh when opened. Right-click the PivotTable, choose PivotTable Options, open the Data tab, and look for Refresh data when opening the file. This can help keep a workbook current when it is opened, but it does not repair a broken connection or make unavailable source data accessible. On shared workbooks, coordinate refreshes when several people depend on the same external source or credentials.

Check formulas and calculation settings in the source

If the PivotTable source contains formulas, refresh and calculation are related but distinct. Excel may be set to manual calculation, in which case formula results can remain stale until recalculated. Check Formulas > Calculation Options > Automatic. You can press F9 on Windows to recalculate formulas, then refresh the PivotTable. On Mac, use the calculation commands on the Formulas tab; shortcut behavior differs by keyboard and Excel version.

For example, if a source column calculates a sales amount from quantity and unit price, verify that the formula results in the source rows are current before judging the PivotTable total. Refreshing a PivotTable does not correct a wrong formula, a formula copied only partway down the source, or text stored where a number is expected. Check a few source rows directly and confirm that the values shown there are the values you expect the summary to use.

When to rebuild the PivotTable

Rebuilding is reasonable if the source structure has changed substantially, the PivotTable is damaged, or you cannot identify a reliable way to correct its source. Before replacing it, record the existing fields, filters, layout, and value calculations. Create a new PivotTable from the verified source and compare its totals with the original. This provides a check against accidentally changing the meaning of the report while trying to fix it.

For an ordinary refresh problem, rebuilding is usually unnecessary. A wrong source range, an inactive filter, a stale query, or retained cache items has a more direct fix. If the PivotTable uses the Data Model or an external connection, its source controls may differ from those for a simple worksheet range; use the connection or query settings rather than trying to force the PivotTable to use a worksheet range it was not designed to summarize.

Prevent the same problem next time

Good source-data habits make refreshes more predictable. Keep one header row, use consistent data types, avoid blank rows within the list, and turn a growing source into an Excel table. If data arrives through a query, check that the query’s destination and refresh status are clear to workbook users. In shared reporting files, note which source is authoritative and whether a refresh requires a sign-in or access to a network location.

When results matter, validate a refresh with a small control check: compare a known record, a category count, or a total calculated independently from the source. This is especially useful after someone changes the source range, query, or PivotTable filters. A PivotTable is a summary tool, not a guarantee that its source and settings are correct; a quick comparison helps catch omissions that a successful refresh message cannot reveal.

Frequently Asked Questions

Why does my PivotTable say it refreshed but show the old numbers?
Excel may have refreshed the wrong source range, the source query may still contain old data, or filters may hide the changed records. Confirm the source value first, then check PivotTable Analyze > Change Data Source, filters, and any query or connection status.

How do I make a PivotTable include new rows automatically?
Base it on an Excel table instead of a fixed range. Add new records directly below the table so it expands, then refresh the PivotTable. Table expansion helps include the rows in the source, but a refresh is still needed to update the summary.

Does Refresh All update every PivotTable?
Data > Refresh All requests updates for workbook connections and PivotTables. The outcome still depends on whether each source is available and whether the PivotTable uses that connection. A connection error or unsupported source will not become current simply because Refresh All was selected.

Why do deleted categories still appear in a PivotTable filter?
The PivotTable may retain old items in its cache. In PivotTable Options > Data, set Number of items to retain per field to None, then refresh. This removes retained labels; it does not fix a missing current category.

Why is the Refresh command unavailable?
Make sure you have selected a cell inside the PivotTable, since its contextual commands appear only when it is active. If the command remains unavailable, check whether the worksheet is protected or whether the workbook’s connection or editing restrictions prevent the action. If needed, try opening the workbook in desktop Excel and inspect its source connection.

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.