Notitie
Voor toegang tot deze pagina is autorisatie vereist. U kunt proberen u aan te melden of de directory te wijzigen.
Voor toegang tot deze pagina is autorisatie vereist. U kunt proberen de mappen te wijzigen.
Refreshes all external data ranges and PivotTable reports in the specified workbook.
Syntax
expression.RefreshAll
expression A variable that represents a Workbook object.
Remarks
Objects that have the BackgroundQuery property set to True are refreshed in the background.
If a Power Query query that loads data into a worksheet table fails during refresh, RefreshAll doesn't raise a run-time error. Other connections are still refreshed, and the affected table retains its previous data. This behavior occurs even when background refresh is disabled for every connection.
To detect these errors, refresh each table's query separately by calling QueryTable.Refresh with BackgroundQuery set to False. Then, handle any error that the method raises. Use ListObject.QueryTable to get the query table for a table loaded by Power Query.
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.