Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

At any time, you can select Refresh to update the data for the PivotTables in your workbook. You can refresh the data for PivotTables imported from Power Query, such as a database (SQL Server, Oracle, Access, and so on), Analysis Services cube, a data feed, and many other sources. You can also refresh data from an Excel table, which automatically includes all changes to its external data source.

By default, PivotTables are not refreshed automatically, but you can specify that the PivotTable is automatically refreshed when you open the workbook that contains the PivotTable.

  1. Select the PivotTable to show the PivotTable Analyze tab.

  2. Select  PivotTable Refresh All button Refresh in the Data group, or press Alt+F5.

    Excel Ribbon Image

    Tip: You can right-click the PivotTable and select Refresh.

  3. To update all PivotTables in your workbook at once, on the PivotTable Analyze tab, select the Refresh arrow and choose  PivotTable Refresh All button Refresh All.

If refreshing takes longer than you expect, on the PivotTable Analyze tab, select the Refresh arrow and choose Refresh Status to check the refresh status.

To stop refreshing, select Cancel Refresh.

If the column widths and cell formatting of your data adjust when you refresh the PivotTable data, and you don’t want that to happen, make sure the following options are checked:

  1. On the PivotTable Analyze tab, select PivotTable Options button Options.

    PivotTable Options button

  2. On the Layout & Format tab, check the Autofit column widths on update and Preserve cell formatting on update boxes.

  1. Select the PivotTable to show the PivotTable Analyze tab on the ribbon.

  2. Select PivotTable Options button Options.

    PivotTable Options button

  3. On the Data tab, check the Refresh data when opening the file box.

  1. Select the PivotTable to show the PivotTable tab on the ribbon.

  2. Select the  PivotTable Refresh All button Refresh All down arrow in the data group, and choose Refresh.

    Tip: You can right-click the PivotTable and select Refresh.

  3. To update all PivotTables in your workbook at once, on the PivotTable tab, select PivotTable Refresh All button Refresh All.

If the column widths of your data adjust when you refresh the PivotTable data, and you don’t want that to happen, make sure the following option is checked:

  1. On the PivotTable tab, select PivotTable Options button Settings.

  2. In the PivotTable Settings pane on the right side, select Autofit column widths on refresh under Sort and display.

  1. On the PivotTable tab, select PivotTable Options button Settings.

  2. In the PivotTable Settings pane on the right side, select Refresh data on file open.

  1. Select the PivotTable to show the PivotTable Analyze tab.

  2. Select  PivotTable Refresh All button Refresh in the Data group.

    Excel Ribbon Image

    Tip: You can control-click the PivotTable and select Refresh.

  3. To update all PivotTables in your workbook at once, on the PivotTable Analyze tab, select the Refresh arrow and choose  PivotTable Refresh All button Refresh All.

If refreshing takes longer than you expect, on the PivotTable Analyze tab, select the Refresh arrow and choose Refresh Status to check the refresh status.

To stop refreshing, select Cancel Refresh.

If the column widths and cell formatting of your data adjust when you refresh the PivotTable data, and you don’t want that to happen, make sure the following options are checked:

  1. Select the PivotTable to show the PivotTable Analyze tab.

  2. Select Options.

  3. On the Layout tab, select the Autofit column widths on update and Preserve cell formatting on update boxes.

  1. Select the PivotTable to show the PivotTable Analyze tab.

  2. Select Options.

  3. On the Data tab, select Refresh data when opening the file.

PivotTable on iPad is available to customers running Excel on iPad version 2.82.205.0 and above. To access this feature, please ensure your app is updated to the latest version through the App Store.

Tap anywhere in the PivotTable to show to the PivotTable tab on the ribbon, and then tap Refresh

PivotTable refresh button in the ribbon on iPad.

Alternatively, you can press and hold on a cell anywhere in the PivotTable range, and then tap Refresh.  

Refresh PivotTable from the context menu on iPad.

Need more help?

You can always ask an expert in the Excel Tech Community or get support in Communities.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×