Workbook.RefreshAll (Excel)

Refreshes all external data ranges and PivotTable reports in the specified workbook.

Objects that have the BackgroundQuery property set to True are refreshed in the background.

ActiveWorkbook.RefreshAll