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" <(E-Mail Removed)> wrote in message
news18BE006-B236-4B4D-9618-(E-Mail Removed)...
> 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