RefreshAll Method
Applies To
Workbook object.
Description
Refreshes all external data ranges and PivotTables in the workbook.
Syntax
expression.RefreshAll
expression Required. An expression that returns a Workbook object.
Remarks
The refresh order is undefined.
Example
This example refreshes all external data ranges and PivotTables in the workbook.
ThisWorkbook.RefreshAll