I Always have this prolblem using DDE. Sometimes it works and other it crashes Excel 2010.

I had a look in the social nets but. I have seen many people with the same proble but non solution.

Thanks

Hi lcapo,

I suggest you refer to this link:
https://social.technet.microsoft.com/Forums/office/en-US/7c8f845d-c4aa-4627-9008-3251d2772536/dde-links-crash-excel-2010-on-windows-7-64bits?forum=excel

The user "Seaman7" solve this issue by VBA code.

Sub KillDDE()
  Dim i, ChannelNumber As Integer
  For i = 1 To 1000
    Application.DDETerminate (i) ' Closes all DDE links whose channels might be open
    Next i
  ChannelNumber = Application.DDEInitiate("prortDDE", "DAX") 'initiates a new channel for a DDE link
  Range("A2").Value = Application.DDERequest(ChannelNumber, "Last")

End Sub

Please try this method and check if it works for you.

Hope it's helpful.

Regards,

Emi Zhang
TechNet Community Su

I tried but I had to restart the computer as before...

Thank you

Not working thanks. Everything was working fine with Windons XP and Excel 2003. Not working with Windows 10 and Excel 2010 (sometimes it works (very few) some other doesn't not work(most of time). Excel 2010 "not responding".

Hi lcapo,

If this code didn't work for you,  I recommend we try to use the Access object model instead of DDE.

http://msdn.microsoft.com/en-us/library/office/ff192120(v=office.15).aspx

Hope it's helpful.

Regards,

Emi Zhang
TechNet Community Su