Application.DeferAsyncQueries Property (Excel)
Gets or sets whether asychronous queries to OLAP data sources are executed when a worksheet is calculated by VBA code. Read/write Boolean.
Version Information
Version Added: Excel 2007
Syntax
expression .DeferAsyncQueries
expression A variable that represents an Application object.
Remarks
Setting the DeferAsyncQueries property to True prevents any asynchronous queries form executing until the CalculateUntilAsyncQueriesDone method is called.