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.
- 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)
- After further troubleshooting with the 3rd party, I've been able to fix the problem. It was due to an Excel Add-in from another provider. This Add-in is also installed on PC2, which has no problems, and so it was not clear initially that this was the issue. However, I disabled this Add-in on the problem PC, and the spreadsheet began to work without any issues. Thereafter, I re-enabled the Add-in, and the spreadsheet is still working. So was the Add-in really the issue? Who knows! One of those things I guess ...
Jan, many thanks again on replying with your suggestions. Have a great day.