EXCEL- Is there a way to slow down the calculation speed?

F

flashflash

I have a spreadsheet which has a large amount of DDE links int
bloomberg. They have recently updated their API DDE so that the updat
frequency is alot higher than before. This is causing the spreadshee
to recalculate to often (pc running close to 100pct all the time). I
there a registry value I can change that slows down the frequency o
excel updating. I dont want to change to manual update due to the fac
the spreadsheet has to be live and updating price changes. Any ideas
 
B

Bernie Deitrick

flashflash,

You could se the calc mode to manual and then use a macro that forces a
calc, and calls itself again using the ontime method, setting the ontime to
the 'just right' interval to keep properly updated.

This example will give you a full minute after the calculation ends:

Sub UpdateMyCalc()
With Application
.CalculateFull
.OnTime Now + TimeValue("00:01:00"), "UpdateMyCalc"
End With
End Sub

HTH,
Bernie
MS Excel MVP
 
Top