Skip to content
Related Articles

Related Articles

Save Article
Improve Article
Save Article
Like Article

Refresh Pivot Table Data in Excel

  • Last Updated : 14 Jun, 2021

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.

Attention reader! Don’t stop learning now. If you are an Excel beginner (or an intermediate) and want to learn Excel, Geeksforgeeks brings the perfect course for you to start, Diving Into Excel

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.

My Personal Notes arrow_drop_up
Recommended Articles
Page :