DDE automatic refresh

  • Thread starter Thread starter Bruce
  • Start date Start date
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
 
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
 
Back
Top