Skip to main content

PivotCache.BackgroundQuery property

Table of contents
  1. Syntax
  2. Remarks
  3. Example

True if queries for the PivotTable report are performed asynchronously (in the background). Read/write Boolean.



expression A variable that represents a PivotCache object.


For OLAP data sources, this property is read-only and always returns False.


This example causes queries for the first PivotTable report on worksheet one to be performed in the background.

Worksheets(1).PivotTables("Pivot1").PivotCache.BackgroundQuery = 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>