Forum Discussion
Excel hangs when running macro a specific PC only
I have a DDE-enabled spreadsheet with a large number of macros. The spreadsheet comes from a 3rd party, and it first needs to connect via API with the 3rd party after running something called DdeSock...
Hi Jan, thanks for your reply. Upon doing what you suggest (but after doing it 2x), the "MS Excel is Not Responding" window opens with 3 choices.
I clicked Close, which then leads to the "Hang on while Windows reports the problem to MS". Excel then closes.
When I then re-open the file, there is a Document Recovery pane. However, the file in there looks identical with the one initially open. In the pane, there was a link which when clicked said there were no errors found.
I tried multiple times without any success, and no resolution.
I clicked Close, which then leads to the "Hang on while Windows reports the problem to MS". Excel then closes.
When I then re-open the file, there is a Document Recovery pane. However, the file in there looks identical with the one initially open. In the pane, there was a link which when clicked said there were no errors found.
I tried multiple times without any success, and no resolution.
I seem to recall that a DDE link can be resource-hungry, perhaps that is the issue? Without knowing more about the code I cannot advise more.