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.
This forum is for the DSWS API service not the excel add in, i would recommend in speaking to the help desk directly in future. However I am aware there are a set of commands to refresh the DSGRID formulas – so if you have auto-calculation always set to off – you can then use these to control when the formulas are refreshed. More info on the doc attached.datastream-dfo-vba-commands-vs4.pdf