BackgroundQuery Property

Applies To

PivotCache object, QueryTable object.

Description

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

Example

This example causes queries for the PivotTable to be performed in the background.

Worksheets(1).PivotTables("Pivot1").PivotCache.BackgroundQuery = True