I frequently get a whited out screen along with the title bar adding the text (Not Responding) most frequently when loading a file but at other times as well. I can't figure out how to get rid of the problem except to close Excel and restart it. This is particularly annoying when I have unsaved VBA code that I then lose. Anybody have any suggestions of how to either stop this from happening or how to deal with it when it does happen? Thanks!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
White Screen of Death
- Thread starter MikeDBMan
- Start date
-
- Tags
- white screen
Excel Facts
Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.
xenou
MrExcel MVP
- Joined
- Mar 2, 2007
- Messages
- 16,836
- Office Version
- 2019
- Platform
- Windows
DoEvents won't necessarily speed it up but (as mentioned) it will allow you to do things like move windows, press keys, and see alert messages or status bar updates - the kind of things that can be useful at times -- including being able to halt program execution and find out what it is doing!
ξ
ξ
Upvote
0
Norie
Well-known Member
- Joined
- Apr 28, 2004
- Messages
- 76,377
- Office Version
- 365
- Platform
- Windows
Mike
Why not check what the loops are (or aren't doing) then trying to fix them?
Stick a breakpoint (F9) on the first line of each loop, start the code and when it breaks step through the loop(s) with F8.
You don't need to go through every iteration, just enough to check that the loop is working OK.
Once you've checked the loop remove the breakpoint(s) from it and press F5 to run on to the next breakpoint.
Why not check what the loops are (or aren't doing) then trying to fix them?
Stick a breakpoint (F9) on the first line of each loop, start the code and when it breaks step through the loop(s) with F8.
You don't need to go through every iteration, just enough to check that the loop is working OK.
Once you've checked the loop remove the breakpoint(s) from it and press F5 to run on to the next breakpoint.
Upvote
0
This has been happening too often since I started using 2016 and it's not just Excel. I've been programming with VBA since it came out and I don't remember ever having to deal with this except in cases where the code really did lock up the program or some other rare case. These aren't real lockups. The program has just stopped responding to user input including ctrl-break.
I can get around the data loss. The real problem is that in some cases, I simply have no way of monitoring longer running routines with loops. I can even program in a "Stop" every thousand loops or so. It has no effect. I get to see that it did in fact enter a stopped state, but only as a flash just before a forced shut down.
The code I'm running today is extremely simple. There's really no other way to do it - just taking the last two characters off of each cell in a large range. I get white screen after about 5 seconds. This isn't the first machine I've used, so I doubt hardware has much to do with it in my case. As a developer, this is far, far beyond the minor annoyance. How do we make sure Microsoft is addressing this?
I can get around the data loss. The real problem is that in some cases, I simply have no way of monitoring longer running routines with loops. I can even program in a "Stop" every thousand loops or so. It has no effect. I get to see that it did in fact enter a stopped state, but only as a flash just before a forced shut down.
The code I'm running today is extremely simple. There's really no other way to do it - just taking the last two characters off of each cell in a large range. I get white screen after about 5 seconds. This isn't the first machine I've used, so I doubt hardware has much to do with it in my case. As a developer, this is far, far beyond the minor annoyance. How do we make sure Microsoft is addressing this?
Upvote
0
Similar threads
- Solved
