| title | keywords | f1_keywords | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
|---|---|---|---|---|---|---|---|---|
PivotTable.PivotCache method (Excel) |
vbaxl10.chm235115 |
|
|
82602154-783d-3f78-b354-0dabfdc34c98 |
05/09/2019 |
medium |
Returns a PivotCache object that represents the cache for the specified PivotTable report. Read-only.
expression.PivotCache
expression A variable that represents a PivotTable object.
PivotCache
This example causes the PivotTable cache for the first PivotTable report on worksheet one to be optimized when it's constructed.
Worksheets(1).PivotTables("Pivot1") _
.PivotCache.OptimizeCache = True
[!includeSupport and feedback]