BackgroundQuery Property Example

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