DDE Links

[Alectrical]

Hi
I have a number of DDE links from which I produce a graph, the links update
at source every second and I use the sheet calculate to update the
spreadsheet, however I find that the sheet updates more than every second.
How can I force the spreadsheet to update the links every second, is there a
time function I can use to do this.
Thanks in Advance
Alec

 

[JLatham]

I'm thinking you could set the workbook's .Calculate option to manual and use
the .OnTimer feature to calculate the sheet (approximately) once per second.

Do a web search for 'Excel OnTime' and you'll get help on setting it up.
These three links should give you a good start:
http://msdn.microsoft.com/en-us/library/aa195809(office.11).aspx
http://www.cpearson.com/excel/OnTime.aspx
http://www.ozgrid.com/Excel/run-macro-on-time.htm

 

[Alectrical]

Thanks for your reply, a shall give it a try.

Is it possibe to update the links when one cell value changes, instead of
using the calculate method. I think this would be a simpler way of solving my
problem.

Thanks
Alec