This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Download Microsoft Edge
More info about Internet Explorer and Microsoft Edge
Refreshes all external data ranges and PivotTable reports in the specified workbook.
Syntax
expression
.
RefreshAll
expression
A variable that represents a
Workbook
object.
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
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.