_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.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Property DeferAsyncQueries As Boolean
Get
Set
'Usage
Dim instance As _Application
Dim value As Boolean
value = instance.DeferAsyncQueries
instance.DeferAsyncQueries = value
bool DeferAsyncQueries { get; set; }
Property Value
Type: System.Boolean
Boolean
Remarks
Setting the DeferAsyncQueries property to True prevents any asynchronous queries form executing until the CalculateUntilAsyncQueriesDone() method is called.