PivotCache.Refresh method (Excel)

Causes the specified PivotCache to be redrawn immediately.

Syntax

expression.Refresh

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

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.