RefreshTable 方法 (Excel)PivotTable.RefreshTable method (Excel)

用源数据刷新数据透视表。Refreshes the PivotTable report from the source data. 如果成功,则返回 TrueReturns True if it's successful.

语法Syntax

表达式RefreshTableexpression.RefreshTable

_表达式_一个代表**PivotTable** 对象的变量。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

支持和反馈Support and feedback

有关于 Office VBA 或本文档的疑问或反馈?Have questions or feedback about Office VBA or this documentation? 请参阅 Office VBA 支持和反馈,获取有关如何接收支持和提供反馈的指南。Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.