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