Open In App

Refresh Pivot Table Data in Excel

Improve
Improve
Like Article
Like
Save
Share
Report

In the Pivot data table, data can be grouped based on Dates, Numbers, and Text values. In the case of dates, we can group dates by months or year, months by years, etc. 

At any time, data for the PivotTables in your workbook can be refreshed using the Refresh button.  You can also refresh data from a source table in the same or a different workbook.  By default, PivotTables are not refreshed automatically when data in the source table is changed, but you can set your workbook to refresh its PivotTable data automatically when you open it.

Steps to Manually refresh:

Follow the below steps to manually refresh PiviotTable Data in Excel:

  • Click on the PivotTable to show the PivotTable Tools on the ribbon.

  • In PivotTable Tools, Click Analyze > Refresh, or press Alt+F5.

  • Click the Refresh button on the Analyze tab (Click Analyze > Refresh All, to update all PivotTables in your workbook at once).

  • If refreshing takes longer, click Analyze > Refresh arrow > Refresh Status to check the refresh status.
  • To stop refreshing, click Cancel Refresh.

Steps to prevent column width and cell formatting while refreshing:

Follow the below steps to prevent column with and cell formatting while refreshing:

  • Click on the PivotTable to show the PivotTable Tools on the ribbon.
  • In PivotTable Tools, Click Analyze.
  • In the first section of Analyze. Click Option->Option.

  • A dialog box will appear, on the Layout & Format tab, check the Autofit column widths on update, and Preserve cell formatting on update boxes.

Automatically update pivot table, every time we open the workbook:

Follow the below steps to automatically update pivot table, every time we open the workbook:

  • Click anywhere in the PivotTable.
  • In PivotTable Tools, Click Analyze.
  • In the first section of Analyze. Click Option->Option.

  • In the PivotTable Options dialog box, on the Data tab, select the Refresh data when opening the file check box.


Last Updated : 14 Jun, 2021
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads