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 connections in the workbook, press Ctrl+Alt+F5 instead.
What the refresh shortcut does
A PivotTable summarizes information from a source, such as a worksheet range, an Excel Table, or an external connection. Excel stores and uses a PivotTable cache so it can display and summarize that information efficiently. Refreshing tells Excel to retrieve the source data again and update the PivotTable’s results.
For example, suppose a PivotTable totals monthly sales by product, and a new sales transaction has been entered into its source data. After a refresh, the transaction can be included in the appropriate product and month totals—provided it falls within the PivotTable’s source. Refreshing updates the summary; it does not edit the original sales records.
To use the single-table shortcut, first click inside the PivotTable. Then press Alt+F5. If the active cell is outside the PivotTable, Excel may not refresh the intended table. The contextual PivotTable Analyze tab appears when a PivotTable cell is selected, and its Refresh command is a useful visual alternative.
Refresh one PivotTable or the whole workbook?
Choose the shortcut according to what needs updating. Alt+F5 is the focused option when you want to refresh the PivotTable you are working with. Ctrl+Alt+F5 is broader: it runs Refresh All for the workbook, including refreshable connections as well as PivotTables.
- Refresh the selected PivotTable: click inside it and press Alt+F5, or select PivotTable Analyze > Refresh.
- Refresh all workbook data: press Ctrl+Alt+F5, or select Data > Refresh All.
- Refresh from a menu: right-click inside a PivotTable and choose Refresh.
Refresh All can take longer than refreshing one table, particularly when a workbook connects to large files, databases, or online services. It can also prompt for credentials or encounter a connection error. Use it when several summaries or connected sources need updating, rather than assuming that it is the necessary choice every time.
PivotTables that share the same underlying cache may be affected by a refresh even if you intended to update only one visible report. If several reports are based on the same source, check their results after refreshing. A PivotTable built from a separate source or connection may need its own refresh.
Make sure the source includes new rows
A refresh can only use data that belongs to the PivotTable’s source. This is a frequent reason a new record does not appear: the data was added below the original source range, so refreshing updates the existing range but does not automatically extend it.
For example, if a PivotTable was created from A1:D100, adding a transaction in row 101 may leave that row out. In that case, select a cell in the PivotTable and choose PivotTable Analyze > Change Data Source. Update the source range to include the added record, then refresh. The exact dialog options can vary with the source type.
For regularly growing worksheet data, formatting the source as an Excel Table before building the PivotTable is often more convenient. Select a cell in the data and use Insert > Table, confirming that the header setting is correct. Excel Tables typically expand when new rows are added directly below them, and a PivotTable based on the table can include those rows after it is refreshed.
Check the structure as well as the range. A source with blank or duplicate column headings, totals mixed into the records, or inconsistent data types can produce confusing fields or summaries. Each source column should have a clear heading, and each row should represent one record. A refresh does not repair problems in the source layout.
What refresh changes—and what it does not
Refreshing updates the PivotTable’s data from its current source. It can bring in changed values, new records within the source, and updated category or item values. It does not ordinarily redesign the report: row and column fields, filters, and value-field choices remain part of the PivotTable setup.
Refresh also does not guarantee that a newly added field will appear in a particular part of the report. If the source has a new column, the field list may need to be checked, and you may need to drag that field into Rows, Columns, Values, or Filters. Similarly, refreshing will not change a text field into a numeric measure or correct a misspelled category in the source.
Refreshing a PivotTable is different from recalculating worksheet formulas. If a formula in the source data has changed, Excel’s calculation settings determine when that formula recalculates; the PivotTable then needs to read the resulting source value. If results still look stale, check both the source formulas and the PivotTable refresh status.
Formatting behavior can depend on the PivotTable’s settings. If formatting disappears or changes after an update, right-click the table, choose PivotTable Options, and review the options related to preserving cell formatting on update. The available settings are separate from the refresh shortcut itself.
Steps when the shortcut does not work
If Alt+F5 appears to do nothing, check the selection and the source before repeatedly pressing keys. A keyboard shortcut can only refresh a PivotTable that Excel recognizes as active, and a successful refresh will not fix an incomplete source range or a broken connection.
- Click a value, label, or other cell inside the PivotTable, then try Alt+F5 again.
- Use PivotTable Analyze > Refresh or right-click and select Refresh to see whether the menu command works.
- Check the source range or connection. For a worksheet source, use PivotTable Analyze > Change Data Source if newly added rows are outside the selected range.
- If the source is external, check whether it is available and whether Excel needs updated credentials or permission to access it.
- For a PivotTable based on the Data Model or another specialized source, confirm that the underlying data or model has updated; refreshing the visible summary alone may not resolve an upstream issue.
Some Windows keyboards require the Fn key for function-row shortcuts, but Alt+F5 is not a function-key-only command. If a laptop or custom keyboard utility intercepts the combination, use the ribbon or right-click command as a practical alternative. The menus also make it easier to confirm which table is selected.
Using Excel on Mac or in a browser
The shortcuts above are for Excel on Windows. On a Mac, keyboard behavior can depend on the keyboard, macOS settings, and whether function keys are configured for standard functions. To avoid relying on a key combination that may be intercepted or mapped differently, select the PivotTable and use the Refresh command on the contextual PivotTable ribbon. For workbook-wide updates, use Data > Refresh All if it is available for the workbook’s data sources.
In Excel for the web, select the PivotTable and look for its refresh command in the PivotTable ribbon or context menu. Availability and behavior can differ for external connections and some workbook features. If a refresh option is missing or a connection cannot update in the browser, open the workbook in the desktop Excel app and use its refresh controls.
Habits that make PivotTable updates more reliable
If a report is used repeatedly, a few small choices can reduce missed records and unnecessary troubleshooting. Start with a clean source table, use consistent headings, and decide whether the report needs just its PivotTable refreshed or every connection in the workbook updated.
- Use an Excel Table for a source that gains rows regularly, then refresh the PivotTable after adding records.
- Keep one record per row and one kind of information per column; avoid inserting subtotal rows into the source records.
- After refreshing, check a total or a known new record against the source to confirm that the report reflects the expected data.
- Use Refresh All when multiple connections or reports need updating, but allow time for large or remote sources.
- If a workbook has a refresh-on-open setting, understand that it may update data when the file opens; this is a setting, not a replacement for checking the source and results.
For shared workbooks, remember that a PivotTable’s displayed data may depend on access to an external source. A colleague can open the workbook but still be unable to refresh a connection if they lack permission or the required credentials. In that situation, the shortcut is working as intended; the connection’s access requirements need attention.
Frequently Asked Questions
What is the shortcut to refresh a PivotTable in Excel?
Select a cell inside the PivotTable and press Alt+F5 in Excel for Microsoft 365 on Windows.
How do I refresh all PivotTables in a workbook?
Press Ctrl+Alt+F5 to run Refresh All. It also refreshes other refreshable data connections in the workbook, so it may take longer than updating one PivotTable.
Why are new rows missing after I refresh?
The rows may be outside the PivotTable’s source range. Use PivotTable Analyze > Change Data Source to extend the range, or use an Excel Table as the source so it can expand as records are added.
Does refreshing a PivotTable change the original data?
No. Refreshing updates the summary from its source; it does not edit the source records.
Can I refresh a PivotTable without a keyboard shortcut?
Yes. Select the PivotTable and choose PivotTable Analyze > Refresh, or right-click inside it and choose Refresh.
Related
- Password Protect Multiple Excel Files at Once in Excel
- Password Protect an Excel File from Being Opened
- Password Protect Excel to Prevent Opening
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Does Excel Goal Seek Automatically Update?No. Excel Goal Seek finds an input value that makes a formula reach a target, then leaves that…
- Excel Solver Add-In: How It Works and How to Use ItExcel Solver is an optimization add-in that finds values for selected cells to maximize, minimize, or reach a…
- Budget Spreadsheet for Couples: Build a Shared Monthly PlanA budget spreadsheet for couples can show shared income, bills, savings goals, and personal spending in one monthly…
- Animated Text in PowerPoint: How to Add and Control ItTo animate text in PowerPoint for Microsoft 365 on Windows, select its text box, open Animations, and choose…
- How to Enable Autofit in Excel for Columns and RowsTo AutoFit in Excel, select the column or row, then double-click the boundary on its right or bottom…
- PowerPoint Slideshow Loop: How to Repeat It ContinuouslyYes. In PowerPoint for Microsoft 365 on Windows, open the presentation, select Slide Show > Set Up Slide…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.