I'm not sure if this is the right place to ask my question but anyway... I use DDE link in Excel and at 10am I want to stop the link. What is the easiest way to do it? I understand I can close Excel and re-open without update, or cut and paste just values. But I wonder if I can just stop the link to TWS? anybody?
I have wrestled with the same issue of cutting off the DDe link since XL repaints everytime a DDE value changes which locked up mu CPU. I finally ended up with putting the DDE link somewhere far to the right, then using cut and paste and deleting the formula to get 'snapshot" values when I need it. In addition, try to use the screenupdate=false as an alternative.