Skip to main content

Workbook.RefreshAll method

Table of contents
  1. Syntax
  2. Remarks
  3. Example

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.

Example

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

Workbooks(1).RefreshAll

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>