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

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" wrote:

> 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

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

"JLatham" wrote:

> 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" wrote:
>
> > 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