Forum Discussion
Expanding a set of grouped rows causing excel to freeze/crash
With your permission, if I can recommend you, add a file (without sensitive data) to your project.
It is much easier for someone who wants to help to understand the subject.
Please no Picture, even if it is said that a picture can say a thousand words, it is certainly not in the case of Excel, on the contrary in some cases, like this case :).
* Knowing the Excel version and operating system would also be an advantage.
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)
NikolinoDE Thanks for your response. I've included an example. Recap of my problem: when i have the attached sheet open, fill my primary monitor with Excel, scroll all the way to the left of the "Grouping Issue" tab, and then click on the + sign on row 22 to expand the grouped rows, Excel freezes up. If I change one little thing about those conditions (i.e. open on second monitor, or not maximize the sheet on my primary monitor), I have no issues. It's a very strange set of circumstances, so i'm not sure if you will be able to replicate the problem on your computer. Thanks again for any help you can provide.
I can't replicate it to myself.
Is the VBA code in the "Assumptions" worksheet wanted?
fade in and fade out is also possible manually.
Have you downloaded the latest video driver version?
With Windows Update, some PCs are very sensitive, although the PC manufacturers should have solved these problems long ago, it happens now and then that after a Windows update, some PCs behave problematically (would rather not mention any brands in a public forum 🙂
Which version of Excel and operating system do you have?
Sorry that I took your time and couldn't give you a quick solution.
Wish you a nice day.
Nikolino
I know I don't know anything (Socrates)
NikolinoDE Thank you so much for your help.
I tried updating the display driver and that did not work. However, since my primary monitor is on the older side, I swapped it out with a newer one that I have and it resolved the issue! I had no idea that hardware could cause Excel to malfunction! Thanks again for your help, I greatly appreciate it!
- I had the same issue
Your remark about changing monitor pointed out for me that it is a monitor issue
Realizing that it is a monitor issue I could resolve it by changing a setting in Excel Options:
General -> User Interface Options (first block) -> select radio button "Optimize for compatibility" instead of "Optimize for best appearance".
