Skip to main content
refresh data when opening the file

VBA: Refresh all pivot tables at once in your excel workbook

Method 1: VBA

Simply make use of:

WorkbookName.RefreshAll

That’s all!

Method 2: By clicking ” Refresh All”

Step 1:  Go to the Data tab.

Step 2: Click on Refresh All button.

Step 3: Done! All tables and links are updated.

excel refresh all button

Method 3: Auto refresh

Step 1: Right click on the your pivot table –> Go to  Table options

Pivot table options

Step 2: Tick the ‘Refresh on open’ option.

refresh data when opening the file

Step 3 : Press on OK.

Leave a Reply

%d bloggers like this: