How to desactivate Datastream auto calculation in VBA ?

Hi,

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.

Best Answer

  • paul.bacon
    paul.bacon LSEG
    Answer ✓

    Hi NICOLAS.BARUSSAUD

    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