RefreshAll Method

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

expression   Required. An expression that returns a Workbook object.

Remarks

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

Example

This example refreshes all external data ranges and PivotTable reports in the third workbook.

Workbooks(3).RefreshAll