In Excel for Microsoft 365 on Windows, select a cell in the PivotTable and press Alt+F5 to refresh it. To refresh all PivotTables and other refreshable data in the workbook, press Ctrl+Alt+F5.
Refresh shortcuts at a glance
The shortcut you need depends on whether you want to update one PivotTable or refresh data throughout the workbook. Click inside a PivotTable before using the single-table shortcut so Excel knows which one to refresh.
- Refresh the selected PivotTable: Alt+F5.
- Refresh all workbook data: Ctrl+Alt+F5. This can update multiple PivotTables and refreshable connections, not just the table currently selected.
- Use the ribbon instead: click inside the PivotTable, then choose PivotTable Analyze > Refresh. For workbook-wide updates, choose Data > Refresh All.
These are Excel shortcuts, not Windows-wide commands. If a laptop uses its function-key row for hardware controls, you may need to hold its Fn key as well, depending on the keyboard and its settings. If the key combination does not work, the ribbon command is a reliable way to confirm that the correct refresh action is available.
How to refresh one PivotTable
A PivotTable may continue to show an earlier result after you change its underlying cells. Refreshing tells Excel to read the source data again and update the summary. To refresh just one table:
- Make sure the source data has been changed or updated.
- Click any cell inside the PivotTable you want to update.
- Press Alt+F5, or select PivotTable Analyze > Refresh.
- Check the totals, labels, and filters to confirm that the refreshed view reflects the change.
The active cell needs to be inside the PivotTable for the context-specific ribbon tab and refresh command to apply to that table. If you click an ordinary worksheet cell first, PivotTable Analyze may disappear. Click back into the PivotTable and try again. Refreshing does not normally erase the source rows; it updates the summary that Excel displays from them.
What refreshing actually does
A PivotTable is a summary view built from source data. Excel stores information used to create that view, often in a PivotTable cache. Refreshing makes Excel check the source again and rebuild or update the summary based on the current records. The visible result can therefore change when source values, rows, or categories have changed.
For example, imagine a sales list with columns for Region, Product, and Amount, summarized by region. If you change a sale from 120 to 150 in the source, the PivotTable may still show the old total until you refresh. After refreshing, Excel includes the revised amount in the summary. If a new product or region appears in the source, refreshing can make it available as a PivotTable item too.
Refreshing is different from recalculating worksheet formulas. Pressing F9 recalculates formulas in the workbook, but it is not a substitute for refreshing a PivotTable whose source data changed. Conversely, refreshing a PivotTable does not necessarily solve a problem caused by a formula elsewhere in the workbook that has not recalculated.
When to use Refresh All
Use Ctrl+Alt+F5 when several PivotTables or connected data sources need updating, or when you are unsure which summaries depend on a changed source. The matching ribbon command is Data > Refresh All. This asks Excel to refresh the workbook’s refreshable data, which can include queries, external data connections, and PivotTables.
Refresh All can take longer than Alt+F5 because Excel may need to contact a database, file, or other connection and then update more than one object. It is useful in a reporting workbook with several summaries based on the same refreshed source. For a large workbook or a slow connection, allow the update to finish before assuming that a particular PivotTable failed to change. Some data connections can run in the background, so a status indicator or connection progress may remain visible briefly.
Choose the one-table command when you only need to update a particular PivotTable and want to avoid refreshing unrelated connections. Choose Refresh All when the workbook contains multiple dependent summaries or external data that should be brought up to date together.
Check the source range if new rows are missing
A frequent misconception is that refreshing always expands the source range to include every row added below the original data. It does not necessarily do so. If the PivotTable was created from a fixed cell range, newly appended rows outside that range may be excluded even after a refresh. In that case, the refresh command worked, but Excel was still looking at the old range.
For future growth, format a contiguous source list as an Excel Table before building the PivotTable. Select a cell in the list and use Insert > Table, making sure the header setting matches the data. Excel Tables typically expand as rows are added directly beneath them, and PivotTables based on the table can use the expanded source after a refresh.
To inspect or change an existing source, click inside the PivotTable and choose PivotTable Analyze > Change Data Source. Check that the displayed table or range includes all intended columns and records. If you change the source range, confirm the dialog and refresh the PivotTable. For a source with blank rows or multiple separated blocks, review the layout too: a clean rectangular list with one header row is generally easier to summarize reliably.
Refresh settings and external connections
You can set a PivotTable to refresh when its workbook opens. In Windows desktop Excel, click in the PivotTable and choose PivotTable Analyze > Options to open PivotTable Options. On the Data tab, select Refresh data when opening the file, then confirm the setting. This is convenient for a workbook that should show current source information when opened, but it may make opening the file slower if the source is large or remote.
Automatic refresh on opening is not the same as refreshing immediately every time a source cell changes. A typical PivotTable does not continuously update its summary after every edit; use Alt+F5 or Refresh All as appropriate. With external sources, a refresh may also depend on access permissions, a working network, credentials, or the source file being available. If Excel prompts for access or reports a connection error, resolve that issue rather than repeatedly pressing the shortcut.
Refreshing a workbook that contains sensitive or shared data can also retrieve newer information than the version a colleague last saw. If a report is intended to preserve a specific snapshot, consider whether refreshing is appropriate before saving or distributing it. A refresh updates the workbook’s displayed results; it does not create a separate historical copy of the source.
Common refresh problems and fixes
- The numbers did not change: verify that the source cells actually changed, that the PivotTable uses the expected source, and that the edited rows are inside its range. Then refresh again.
- A new category is missing: refresh the PivotTable and inspect the source range. A category will not appear if its source row is outside that range or filtered out.
- The shortcut seems to do nothing: click inside the PivotTable first. On some keyboards, try the Fn key with the shortcut, or use PivotTable Analyze > Refresh.
- An external-data refresh fails: check the connection, access permissions, credentials, and availability of the source. A keyboard shortcut cannot repair a broken or inaccessible connection.
- Old items remain in a filter list: the PivotTable may retain items that are no longer in the source. Review PivotTable Options and its data-retention settings if stale entries persist; changing retention behavior can affect which items remain available in filters.
If the summary still looks wrong, inspect the source for inconsistent headers, blank columns, text stored where numbers are expected, or filters that hide records. Refreshing updates a summary from the data and settings Excel has; it does not correct errors or inconsistencies in the source itself.
Excel for Mac and Excel for the web
On Excel for Mac, the ribbon commands are the clearest alternative: select a PivotTable and choose PivotTable Analyze > Refresh, or use Data > Refresh All for workbook-wide data. The Mac keyboard shortcut for refreshing a selected PivotTable is commonly Option+F5; keyboard settings and function-key behavior can affect whether you need to include Fn. If that combination is unavailable on your Mac, use the ribbon command rather than assuming the Windows keystroke will behave identically.
In Excel for the web, use the available refresh commands on the ribbon, such as Data > Refresh All, because browser and keyboard settings can intercept key combinations. Support for refreshing can depend on the workbook’s data source and connection type. If a command is unavailable in the web version, open the workbook in the desktop app and use its PivotTable or connection refresh controls.
Frequently Asked Questions
What is the shortcut to refresh a PivotTable in Excel?
In Excel for Microsoft 365 on Windows, click inside the PivotTable and press Alt+F5. This refreshes the selected PivotTable.
What shortcut refreshes all PivotTables in a workbook?
Press Ctrl+Alt+F5 in Windows Excel to run Refresh All. It can update other refreshable workbook data connections as well as PivotTables.
Why does my PivotTable not include newly added rows?
The added rows may sit outside the PivotTable’s source range. Check PivotTable Analyze > Change Data Source, or use an Excel Table as the source so a growing list is easier to accommodate, then refresh.
Does a PivotTable refresh automatically when I edit its source?
Usually, no. Refresh it with Alt+F5, or enable Refresh data when opening the file in PivotTable Options if updating on workbook open suits your workflow.
Is refreshing the same as pressing F9?
No. F9 recalculates formulas; refreshing asks a PivotTable or data connection to retrieve or reread source data. Use the command that matches what changed.
Can I refresh a PivotTable without a keyboard shortcut?
Yes. Click inside it and choose PivotTable Analyze > Refresh. To update refreshable data across the workbook, choose Data > Refresh All.
Related
- Excel Paste Keyboard Shortcuts: Copy, Paste Special & More
- Excel Packing List Template: What to Include and How to Use
- Excel Ordinal Number Format: Show 1st, 2nd, and 3rd
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Keyboard Shortcut to Add a Row (Windows & Mac)In Excel for Microsoft 365 on Windows, select the row where the new row should go, then press…
- Excel Find and Replace Carriage Returns: Steps and FixesIn Excel for Microsoft 365 on Windows, press Ctrl+H, click the Find what box, and press Ctrl+J to…
- Google Sheets for Data Analysis: Tools and LimitsYes. Google Sheets can analyze data using formulas, filters, pivot tables, charts, and conditional formatting; it is Google’s…
- Excel Time Zones: How Date and Time Conversion WorksExcel does not assign a time zone to a date or time value: a worksheet cell holds a…
- Conditional Formatting in Microsoft Forms: What Works?Microsoft Forms does not have a built-in conditional-formatting feature for changing question or answer colors based on a…
- How to Delete a Named Cell Range in Excel CorrectlyIn Excel for Microsoft 365 on Windows, open Formulas > Name Manager, select the defined name, choose Delete,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.