Forum Discussion
akoo371
Nov 22, 2020Copper Contributor
Expanding a set of grouped rows causing excel to freeze/crash
In one of my workbook sheets, I have a section of about 10 rows that I've grouped together. When I go to ungroup the rows using the "+" sign, it freezes Excel -- BUT, it only freezes if I'm scrolled ...
akoo371
Copper Contributor
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!
JimVanDam
Oct 23, 2021Copper Contributor
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".
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".