Home » learn » PivotTable.RefreshTable method

PivotTable.RefreshTable method

1 minute to read
18 0
Table of contents
  1. Syntax
  2. Return value
  3. Example

Refreshes the PivotTable report from the source data. Returns True if it's successful.

Syntax

expression.RefreshTable

expression A variable that represents a PivotTable object.

Return value

Boolean

Example

This example refreshes the PivotTable report.

Set pvtTable = Worksheets("Sheet1").Range("A3").PivotTable 
pvtTable.RefreshTable
❮ PreviousNext ❯

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>