RefreshAll Method

Microsoft Excel Visual Basic

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

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.

Example

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

Workbooks(3).RefreshAll