I made a macro that write several =DSGrid formulas in a worksheet. By default, each formula is auto evaluated as soon as it is entered so that the datastream update popup does not stop to appear, disappear, appear, disappear, etc, etc...
To avoid that I would like to desactivate auto calculation.
I know how to do with Excel Datastream ribbon (Section "Manage Requests" -> Button "Refresh Data" -> "Auto Calculation") but is it possible to do it in VBA ? Then I use Application.Run "PLRefreshWorkbookEventHandler" to refresh all formulas at once.