_Application.DeferAsyncQueries property

Office 2013 and later

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

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