RefreshAll Method

Microsoft Excel Visual Basic

RefreshAll Method

       

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