Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

_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)
bool DeferAsyncQueries { get; set; }

Property value

Type: System.Boolean
Boolean

Setting the DeferAsyncQueries property to True prevents any asynchronous queries form executing until the CalculateUntilAsyncQueriesDone() method is called.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.