Excel not responding

teachman

Active Member
Joined
Aug 31, 2011
Messages
321
Hello,

I have stumbled upon a new and disconcerting behavior when running a macro in Excel 2013 (Windows 7). I'll start a longish macro and the Excel window will go to a white screen with the words 'Excel not responding' in the window title bar. The mouse icon shows it is busy and sooner or later (sometimes before the macro finishes but always after the macro finishes) the Excel window will display normally. The macro seems to have done its thing.

I have added wording to the status bar so the user will know what is happening, but when the Excel window goes white there is no status bar displayed so neither I nor the user knows what the macro is doing.

I have 16 gigs of installed physical memory. This is a fairly new occurrence. It didn't happen right after Excel 2013 was installed on my machine. In fact, it just started this behavior, last week.

Any ideas what is going on and/or how to avoid it? While I have grown used to it the current behavior is very disconcerting to the users.

Thanks,

George Teachman
 

Some videos you may like

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

Declamatory

Active Member
Joined
Nov 6, 2014
Messages
312
Have you tried running your macro one step at a time (pressing F8 in view code) to see if it is having particular trouble in one part of the code?
 

teachman

Active Member
Joined
Aug 31, 2011
Messages
321
No, I haven't done that. I haven't changed the macro in a week or so. But, I guess that's the next step.

Thanks,

George
 

Watch MrExcel Video

Forum statistics

Threads
1,127,563
Messages
5,625,532
Members
416,116
Latest member
Joemamasuka

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
Top