question

Upvotes
Accepted
NICOLAS.BARUSSAUD avatar image
1 ●0 ●0 ●1

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.

eikon-com-apidatastream-apidsws-apivba
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

1 Answer

Upvotes
Accepted
paul.bacon avatar image
446 ●2 ●2 ●2

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


datastream-dfo-vba-commands-vs4.pdf (370.6 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Click below to post an Idea Post Idea