Sign in with Microsoft
New to Microsoft? Create an account.

At any time, you can click 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. Click anywhere in the PivotTable to show the PivotTable Tools on the ribbon.

    PivotTable Tools

  2. Click Analyze > Refresh, or press Alt+F5.

    Excel Ribbon Image
     

    Tip: You can also refresh the PivotTable by right-clicking on the PivotTable, and then selecting Refresh.

  3. To update all PivotTables in your workbook at once, click Analyze > Refresh arrow > Refresh All.

If refreshing takes longer than you expect, click Analyze > Refresh arrow > Refresh Status to check the refresh status.

To stop refreshing, click 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. Click Analyze > Options.

    Options button on the Analyze tab

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

  1. Click anywhere in the PivotTable to show the PivotTable Tools on the ribbon.

    PivotTable Tools

  2. Click Analyze > Options.

    Options button on the Analyze tab

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

  1. Click anywhere in the PivotTable to show the PivotTable Tools on the ribbon.

    PivotTable Tools

  2. Click Analyze > Refresh, or press Alt+F5.

    Excel Ribbon Image

    Tip: You can also refresh the PivotTable by right-clicking on the PivotTable, and then selecting Refresh.

  3. To update all PivotTables in your workbook at once, click Analyze > Refresh arrow > Refresh All.

If refreshing takes longer than you expect, click Analyze > Refresh arrow > Refresh Status to check the refresh status.

To stop refreshing, click 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. Click Analyze > Options.

    Options button on the Analyze tab

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

  1. Click anywhere in the PivotTable to show the PivotTable Tools on the ribbon.

    PivotTable Tools

  2. Click Analyze > Options.

    Options button on the Analyze tab

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

  1. Click anywhere in the PivotTable to show the PivotTable Tools on the ribbon.

    PivotTable Tools

  2. Click Analyze > Refresh, or press Alt+F5.

    Excel Ribbon Image

    Tip: You can also refresh the PivotTable by right-clicking on the PivotTable, and then selecting Refresh.

  3. To update all PivotTables in your workbook at once, click Analyze > Refresh arrow > Refresh All.

If refreshing takes longer than you expect, click Analyze > Refresh arrow > Refresh Status to check the refresh status.

To stop refreshing, click 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. Click Analyze > Options.

    Options button on the Analyze tab

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

  1. Click anywhere in the PivotTable to show the PivotTable Tools on the ribbon.

    PivotTable Tools

  2. Click Analyze > Options.

    Options button on the Analyze tab

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

Need more help?

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

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Office Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×