Excel.PivotTable.RefreshTable.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
PivotTable.RefreshTable method (Excel)	vbaxl10.chm235092	vbaxl10.chm235092	Excel.PivotTable.RefreshTable	778743e3-c53a-23e3-73c6-c18339cd1ac2	05/09/2019	medium

PivotTable.RefreshTable method (Excel)

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

[!includeSupport and feedback]