Application.DeferAsyncQueries Property
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
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.