Skip to main content

PivotTable.PivotCache method

Table of contents
  1. Syntax
  2. Return value
  3. Example

Returns a PivotCache object that represents the cache for the specified PivotTable report. Read-only.



expression A variable that represents a PivotTable object.

Return value



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

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>