PivotCache 方法 (Excel)PivotCache.Refresh method (Excel)

立即重新绘制指定的图表。Causes the specified chart to be redrawn immediately.

语法Syntax

expression.Refreshexpression.Refresh

_表达式_一个代表**PivotCache** 对象的变量。expression A variable that represents a PivotCache object.

示例Example

此示例刷新工作簿中第一个工作表上的第一个数据透视表的数据透视表缓存。This example refreshes the PivotTable cache for the first PivotTable report on the first worksheet in a workbook.

Worksheets(1).PivotTables(1).PivotCache.Refresh

支持和反馈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.