PivotCache.BackgroundQuery Property (Excel)

Office 2013 and later

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

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

expression .BackgroundQuery

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