Under Windows 10, my tws dde excel spreadsheet can't open and freezes excel for the first let say 5min after windows started up. Excel is not responding during this time (XL 2010 or 2013, I have tried both and have tried various machines with Win10) If the spreadsheet is opened beyond this 5min delay there is no issue. Have you experienced this? Any fix? WINDOWS 10 / TWS API 9.71 / EXCEL 2013
DDE is an old protocol, so this is not surprising. Have you tried running Excel in High Priority ? C:\Windows\System32\cmd.exe /c START "" /High "C:\Program Files\Microsoft Office 15\root\office15\EXCEL.EXE"
Yes, thanks but it doesn't solve the problem At startup it seems it is waiting for some Windows services to complete or is in conflict with some services. Once the startup has completed and all delayed services are up and running (after a few minutes), opening the spreadsheet does not suffer any delay.
Try googling the issue, there are a lot of posts on Microsoft support forums and elsewhere with people experiencing DDE issues on Windows 10, most of them seem to be resolved by upgrading to a later build. For long term - syswizard is right, Microsoft announced that they stopped development/active support of DDE about 10 years ago i think.. Try switching to ActiveX at least.
There are many issues at shutdown or with explorer in previous Windows 10 builds, these seem to have been fixed. I have not found specifically my issue in google but you are right it is not surprising given the fact DDE is old and not supported. Switching to ActiveX some quite elaborated tools in DDE represent a significant work and risk unfortunately.
Have you tried checking all of the Windows services and make sure they are set to "Manual" or "Automatic" and not "Automatic (Delayed Start) ???
I had the same idea and forced to automatic everything that was 'delayed start' with no success. I saved all the Service activity as well and couldn't find what was blocking. Windows 10 is doing something at startup that clashes with the DDE but I haven't found out what. Thanks for the idea anyway.