getting out of "Not Responding"

coodeebuu

New Member
Joined
Apr 6, 2005
Messages
24
Is there any way to stop a macro from running when it gets hung up and my excel is "Not Responding"? Now I have to blow it up which is not a desirable method especially when I have made changes that I wanted to save.
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
Usually CTRL-Break works, but if you Excel is not responding, I don't know if you have method to do that.

The bigger question is "why is your macro hanging up?".
Do you have some code in there that needs re-writing?
You may be able to add some error trapping to avoid this situation.

If you can post your code and explain what is happening (and where it might be hanging up), we may be able to help you fix it.
 
Upvote 0
I have a related "not responding" problem with a couple of multi-worksheet workbooks. Each worksheet has many formulas, many cross-references to other worksheets, and several calls to macro subs and functions. There are too many of these items for me to easily use VBA debugging methods, although I did incorporate quite a few while the workbooks were still in the development phase.

These workbooks are in frequent use for adding data rows; the formulas etc. in previous rows do not need recalculation. But even if I open them in safe mode - which should avoid recalculation - the problem still recurs, especially when saving and closing each workbook.

When "not responding" occurs (very frequently now), I can find no method of breaking into the process to see what is happening to cause it. The only things I can do are:
  1. Wait in the hope that Excel will start responding again
  2. Use the Task manager to crash Excel and hope that I have not lost too much new data.

Is there any way of monitoring and/or logging exactly what happens, when, and where, so that I may have a chance of tracing what is going wrong?
 
Upvote 0
I have a related "not responding" problem with a couple of multi-worksheet workbooks. Each worksheet has many formulas, many cross-references to other worksheets, and several calls to macro subs and functions. There are too many of these items for me to easily use <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help;">VBA</acronym> debugging methods, although I did incorporate quite a few while the workbooks were still in the development phase.
Excel might not be the right tool for the job. When I hear things like "multiple worksheets/workbooks" and many "cross-references", it sounds to me like what you are really trying to develop is a relational database, and Excel is not a very good tool for something like that. Database programs like Access, or bigger database options like SQL, MySQL, or Oracle are better tools to use for those sort of things.
 
Upvote 0
Excel might not be the right tool for the job. When I hear things like "multiple worksheets/workbooks" and many "cross-references", it sounds to me like what you are really trying to develop is a relational database, and Excel is not a very good tool for something like that. Database programs like Access, or bigger database options like SQL, MySQL, or Oracle are better tools to use for those sort of things.

Joe4, you may be right in principle, but I do not have the option.

Also these Excel applications have been running without this problem for several years up until a few weeks ago. Microsoft Office Technical Support have checked things for me and reported that there is nothing they can find. So it is obvious to me that some VBA "enhancements" I have made recently cannot be working efficiently. The only way I think I can find the culprits is to trace the details of what is happening in the VBA SUBs and somehow pinpoint the processes that are taking the time.

If there are no tools for doing the trace, then I will have to insert tracing code everywhere that I think it might be relevant. I just hoped (and still do) that someone may have some bright ideas about how to achieve the same end painlessly.
 
Upvote 0
so what changed a few weeks ago
 
Upvote 0
so what changed a few weeks ago
In the most troublesome workbook, I replaced a complicated formula with a VBA sub. That sub should not be volatile - which is what I have not yet tried out!

Thanks for asking a most significant question.
 
Upvote 0

Forum statistics

Threads
1,213,484
Messages
6,113,924
Members
448,533
Latest member
thietbibeboiwasaco

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top