Refreshes all external data ranges and PivotTable reports in the specified workbook.
Syntax
expression.RefreshAll
expression Required. An expression that returns a Workbook object.
Remarks
Objects that have the BackgroundQuery property set to True are refreshed in the background.