Workbook.RefreshAll Method (Excel)
Refreshes all external data ranges and PivotTable reports in the specified workbook.
expression A variable that represents a Workbook object.
Objects that have the BackgroundQuery property set to True are refreshed in the background.
This example refreshes all external data ranges and PivotTable reports in the third workbook.