How to Refresh Pivot Table in Excel: 4 Effective Ways

Method 1 – Refresh Pivot with Right Click of the Mouse

STEPS:

  • Click anywhere in the pivot table.
  • Right-click on the table and select Refresh.

Refresh Pivot with Right Mouse Button

  • Refresh the pivot table as shown in the picture. We can see that the Nissan brand now has only one car on the list.

Refresh Pivot with Right Mouse Button


Method 2 – Pivot Options to Refresh Automatically While Opening the File

STEPS:

  • Select anywhere in the pivot table.
  • In the second place, go to the PivotTable Analyze tab from the ribbon.
  • From the Options drop-down menu, select Options.

  • Instead of doing this, just right-click on the table and select PivotTable Options.

How to Refresh Pivot Table

  • The PivotTable Options dialog box will appear.
  • Go to the Data menu.
  • Checkmark the Refresh data when opening the file.
  • Click on the OK button.

  • View the card, which is red and now shown in the pivot table. Mainly the pivot table is updated now.

Pivot Options to Refresh Automatically While Opening the File


Method 3 – Refresh Pivot Data from PivotTable Analyze Tab

STEPS:

  • Go to the PivotTable Analyze tab on the ribbon.
  • Click on the Refresh drop-down menu.
  • Select Refresh.

Refresh Pivot Data from PivotTable Analyze Tab

  • We can see the result.

Refresh Pivot Data from PivotTable Analyze Tab

If your worksheet has multiple pivot tables, you can refresh all of them by clicking on the Refresh All option.


Method 4 – VBA Code to Refresh Pivot table in Excel

STEPS:

  • Right-click on the sheet where the pivot table is located.
  • Go to the View Code.

  • Copy and paste the VBA code below.
  • If you have multiple pivot tables in your worksheet.

VBA Code:

Private Sub Sheets()
Application.EnableEvents = False
Me.PivotTables(1).RefreshTable
Application.EnableEvents = True
End Sub
  • To Run the code, press the F5 key or click the Run Sub button.

VBA Code to Refresh Pivot table in Excel

  • This will refresh the pivot table.


Things to Remember

  • We can easily refresh all the pivot tables with a keyboard shortcut. To do this, just click anywhere on the pivot table then press the Alt + F5 key. It will refresh all the pivot tables on the spreadsheet.

Download Practice Workbook

You can download the workbook and practice with them.


Refresh Pivot Table : Knowledge Hub


Get FREE Advanced Excel Exercises with Solutions!
Sabrina Ayon
Sabrina Ayon

Sabrina Ayon, a Computer Science and Engineering graduate from United International University, has been an integral part of the ExcelDemy project for two years. She authored 150+ articles, excelling in instructing through visually engaging Excel tutorials. With a passion for teaching, Sabrina conducted sessions on Excel VBA, sharing her knowledge and insights with others. Currently holding the position of Project Manager for the ExcelDemy Visual Development Project, she oversees various aspects of the project, ensuring its smooth operation... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo