DDE automatic refresh

B

Bruce

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
 
P

Peter T

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
 
Top