Application.DeferAsyncQueries Property

Excel Developer Reference

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.

See Also