Hi,

I have an Excel 2003 workbook with a DDE link.

Does DDE automatically refresh as it currently doesn't unless I double click
the DDE formula. The DDE help suggests I need to do this to update my data.

Is there a way set auto update either by;
1. automatically triggering update sy once per minute
2. turning on an option somewhere in my workbook
2. Via VBA macro

Regards,

Bruce

See UpdateLink in VBA help.

You could call this say every minute with an Ontime macro (be sure to cancel
it when closing the file)

Regards,
Peter T

"Bruce" wrote in message
...
Hi,

I have an Excel 2003 workbook with a DDE link.

Does DDE automatically refresh as it currently doesn't unless I double
click
the DDE formula. The DDE help suggests I need to do this to update my
data.

Is there a way set auto update either by;
1. automatically triggering update sy once per minute
2. turning on an option somewhere in my workbook
2. Via VBA macro

Regards,

Bruce