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...
Once Excel appears to hang, can you right-click it's button on the task-bar and choose close window? What happens if you do?
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.
- Thanks Jan. The thing is the "problem" PC is more powerful than my laptop (PC2) on which the spreadsheet works just fine. So I'm not sure it's an issue with resources.
- Can you post the code of the macro you mentioned which makes Excel "Hang"? (be sure to remove any sensitive information such as credentials and API keys)
