Support Board
Date/Time: Tue, 04 Feb 2025 14:40:56 +0000
Excel with active DDE crashes when SC 2029-2038 is running
View Count: 821
| [2020-01-22 17:15:52] |
| caligola - Posts: 116 |
|
Dear support, I found an issue with SC 2029-2038: Excel hangs indefinitely opening files including DDE link IF SC is running. It never happend before and it solves rolling back SC to SC 2028 Procedure: - Start SC 2029-2038 - Open an Excel file with a formula linked to Metatrader4 by DDE - Excel hangs indefinitely opening the file - Excel opens the file as soon as SC is manually closed Please note that this is fully reproducible (it happens 100% of the times) Please also note that Excel file opens smoothly rolling back to SC 2028, issue started with SC 2029 In attachment you could find a minimal excel file to test it |
Private File |
| [2020-01-22 17:17:08] |
| |
|
We are declining support for this. This is a Microsoft issue. It just proves why Microsoft software is so bad. And why we have removed support for Excel.
Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing Date Time Of Last Edit: 2020-01-22 17:17:25
|
| [2020-01-22 17:20:19] |
| caligola - Posts: 116 |
|
No, It's not the case of Excel used WITH Sierra. I know you removed the support for this. Here the issue is that SC is not allowing me to use Excel for other task not related with Sierra |
| [2020-01-22 17:30:53] |
| caligola - Posts: 116 |
|
Are you really telling me that SC decided that I can't use Excel for other my personal stuff not related with SC when SC 2029+ is running and that this is a Microsoft issue?
Date Time Of Last Edit: 2020-01-22 17:32:33
|
| [2020-01-22 17:43:26] |
| |
|
The problem is on the Microsoft side. This is not a Sierra Chart issue. Understand that. We understand these things. This is not in any way a Sierra Chart issue. Your conclusions are wrong! Sierra Chart does not interfere with Microsoft Excel in any way. There is some problem on the Excel side. Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
| [2020-01-22 17:52:54] |
| caligola - Posts: 116 |
|
Your conclusions are wrong!
Sierra Chart does not interfere with Microsoft Excel in any way. There is some problem on the Excel side. You interfere indeed and was not easy for me to understand it because it looked impossible to me too. It took me some time to understand why I was not able to use my excel files not related to SC. In the first post of this thread I wrote a clear and fully reproducible procedure that works 100% of the times. The only variable in test is SC > or < 2028, it's not difficult, just test it before saying I am wrong |
| [2020-01-22 18:07:21] |
| caligola - Posts: 116 |
|
update: Excel 2019 or 2016 with win 10 manages to open the file Excel 2007 with win 7 hangs indefinitely with SC 2029+ Date Time Of Last Edit: 2020-01-22 18:43:53
|
| [2020-01-22 20:10:08] |
| Sierra_Chart Engineering - Posts: 18240 |
|
We contemplated this a little more, one thing that we understand about Windows dynamic data exchange is that if on the system there is a window part of a thread which is not getting and dispatching messages, then it can block DDE. However, all windows within Sierra Chart will be associated with threads that are responsive and getting and dispatching messages and there has been no recent changes to any of this. There are no new windows created on background threads. And as long as the user interface of Sierra Chart is responsive it will not cause a problem with DDE. Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing Date Time Of Last Edit: 2020-01-22 20:10:38
|
| [2020-01-23 06:29:06] |
| caligola - Posts: 116 |
|
Thanks for your investigation It is likely that the old setup Excel 2007 + Win 7 64 bit there is some other reason for DDE to hang that was hit in the 2028 --> 2029 update but I can accept that SC is not going to investigate further for an issue on a so old setup |
To post a message in this thread, you need to log in with your Sierra Chart account: