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.
-
Select the PivotTable to show the PivotTable Analyze tab.
-
Select
Tip: You can right-click the PivotTable and select Refresh.
-
To update all PivotTables in your workbook at once, on the PivotTable Analyze tab, select the Refresh arrow and choose
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:
-
On the PivotTable Analyze tab, select
-
On the Layout & Format tab, check the Autofit column widths on update and Preserve cell formatting on update boxes.
-
Select the PivotTable to show the PivotTable Analyze tab on the ribbon.
-
Select
-
On the Data tab, check the Refresh data when opening the file box.
-
Select the PivotTable to show the PivotTable tab on the ribbon.
-
Select the Refresh All down arrow in the data group and choose Refresh.
Tip: You can right-click the PivotTable and select Refresh.
-
To update all PivotTables in your workbook at once, on the PivotTable tab, select 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:
-
On the PivotTable tab, select
Tip: You might need to select Show in the ribbon to get to Settings.
-
In the PivotTable Settings pane on the right side, select Autofit column widths on refresh under Sort and display.
-
On the PivotTable tab, select
Tip: You might need to select Show in the ribbon to get to Settings.
-
In the PivotTable Settings pane on the right side, select Refresh data on file open.
-
Select the PivotTable to show the PivotTable Analyze tab.
-
Select
Tip: You can control-click the PivotTable and select Refresh.
-
To update all PivotTables in your workbook at once, on the PivotTable Analyze tab, select the Refresh arrow and choose
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:
-
Select the PivotTable to show the PivotTable Analyze tab.
-
Select Options, then Options again.
-
On the Layout tab, select the Autofit column widths on update and Preserve cell formatting on update boxes.
-
Select the PivotTable to show the PivotTable Analyze tab.
-
Select Options, then Options again.
-
On the Data tab, select Refresh data when opening the file.
Important: 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.
Alternatively, you can press and hold on a cell anywhere in the PivotTable range, and then tap Refresh.
Need more help?
You can always ask an expert in the Excel Tech Community or get support in Communities.
