Login Page - Create Account

Support Board


Date/Time: Thu, 27 Feb 2020 05:48:01 +0000



Excel with active DDE crashes when SC 2029-2038 is running

[2020-01-22 17:15:52]
caligola - Posts: 86 | Ending Date: 2020-05-08
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]
Sierra Chart Engineering - Posts: 81519 | Ending Date: 2020-06-09
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. If possible please keep your questions brief and to the point. Please be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

If your question/request has been answered and you do not have anything further, then it is easiest for us if you do not reply again to say thank you.
Date Time Of Last Edit: 2020-01-22 17:17:25
[2020-01-22 17:20:19]
caligola - Posts: 86 | Ending Date: 2020-05-08
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: 86 | Ending Date: 2020-05-08
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]
Sierra Chart Engineering - Posts: 81519 | Ending Date: 2020-06-09
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. If possible please keep your questions brief and to the point. Please be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

If your question/request has been answered and you do not have anything further, then it is easiest for us if you do not reply again to say thank you.
[2020-01-22 17:52:54]
caligola - Posts: 86 | Ending Date: 2020-05-08
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: 86 | Ending Date: 2020-05-08
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: 535 | Ending Date: 2020-11-26
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. If possible please keep your questions brief and to the point. Please be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation
Date Time Of Last Edit: 2020-01-22 20:10:38
[2020-01-23 06:29:06]
caligola - Posts: 86 | Ending Date: 2020-05-08
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 login with your Sierra Chart account:

Login

Login Page - Create Account