Forum Discussion
Solved
SOLVED - Editing cell causes my computer to glitch then crash
Hello all,
When clicking into a cell in Excel, I periodically experience a graphical glitch that results in my computer needing to be force-closed. Does anyone else get this issue? If so, any thoughts on what the cause could be and how to fix it? Thank you!
Update
I don't understand the root cause and it isn't very pleasant, but I think it's something to do with how Excel interacts with my computer internally. Regardless, here's some things that may work for anyone who may have this issue and what kinda works for me.
1. WIN+Ctrl+Shift+B (refresh graphics card).
2. For a laptop, shut the lid and wait a moment then open it again (this will stop the issue for me most of the time unless it's completely frozen but for some reason, my internet is completely inoperable afterward unless I restart my PC). For a desktop, try unplugging your monitor then plug back in.
3. Reinstall (repair) office through Programs on Control Panel (won't affect your files).
4. Force shut down your PC then turn it back on.
Aside from unhelpful research, those were some things I did to take action on the issue. Please reply with any other or better solutions to my problem, even if it's hardware related.
Update
I don't understand the root cause and it isn't very pleasant, but I think it's something to do with how Excel interacts with my computer internally. Regardless, here's some things that may work for anyone who may have this issue and what kinda works for me.
1. WIN+Ctrl+Shift+B (refresh graphics card).
2. For a laptop, shut the lid and wait a moment then open it again (this will stop the issue for me most of the time unless it's completely frozen but for some reason, my internet is completely inoperable afterward unless I restart my PC). For a desktop, try unplugging your monitor then plug back in.
3. Reinstall (repair) office through Programs on Control Panel (won't affect your files).
4. Force shut down your PC then turn it back on.
Aside from unhelpful research, those were some things I did to take action on the issue. Please reply with any other or better solutions to my problem, even if it's hardware related.
You say I periodically experience a graphical glitch that results in my computer needing to be force-closed
For a full diagnosis we'd need to ask a few more questions (and even then might only be a little bit closer to the cause)
- What do you mean by "periodically"?
- Is it a regular "period" -- e.g., today is Tuesday, this always happens on Tuesday--or a random period
- What kind of frequency is attached to the period? Once in a month, quarterly, weekly, several random times a month....
- Is there a pattern connected to a particular spreadsheet?
- Is it always (or almost always) with the sheet shown in the image, or does it happen with others?
- If there's a connection with one or two (or several, but not all), what is distinctive about that particular (or those particular) spreadsheet(s)?
- Or is it random?
- Can you give more details of what you mean by "graphical glitch"?
- When you re-boot the software, has anything been lost?
- Does this happen with any software other than Excel?
- What computer are you on?
- What OS?
- What version of Excel?
- mathetes, I'm running Windows 10 with Excel Version 2102 (Build 13801.20864 Click-to-Run) and Microsoft Visual Basic for Applications 7.1 Version 1108. By graphic glitch, I mean it looks like the picture above and I can't interact, having to force shut down my PC. It is random, and the only thing so far that causes it is clicking into the cell to edit it. When I reopen, it saves from when I last saved. It's not just on my one workbook, but any of them.
Sorry -- I don't have any ideas yet, as to cause, but for those who might, it seems to me that there's still some clarity needed.
Your original statement described this as happening periodically; your last statement sounds more universal (" It's not just on my one workbook, but any of them.").
So now I'm wondering, unless you just can't do ANYTHING with Excel, if there's something about certain cells and the references in them (or something else) such that clicking into cell X but not cell Y causes the problem.
Are other systems open at the time? How many? [As a general observation, it's certainly true that if the computer is being overtaxed with many windows open, it's more likely to freeze.]
The more you can describe when this does NOT happen, as contrasted with when it DOES, the closer we would be to figuring out the cause.
Have you considered updating your software? I don't have any reason to suspect that that would be causally related, but that seems pretty old; there are a lot of new and powerful features.
- What do you mean by "periodically"?
