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 the following conditions are met: If I'm scrolled all the way over to the left of the sheet - if I scroll over even one column so that column A is no longer showing, I can expand without issue. If Excel is maximized on my monitor - if I'm anything less than full screen, I can expand without issue. If I'm on my primary monitor - if I drag excel over to my second monitor, I can expand/regroup without any issue, whether maximized or not. I've never had this issue with any other workbook, and I'm completely stumped since it's such a narrow set of circumstances that causes this -- however, this set of circumstances is how I use excel and the sheet 99% of the time, so it's a big problem for me!

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.

Expanding Grouped Rows Freezing Excel

Thread starter aeon371
Start date Nov 21, 2020

aeon371

New Member

Nov 21, 2020

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 the following conditions are met:

If I'm scrolled all the way over to the left of the sheet - if I scroll over even one column so that column A is no longer showing, I can expand without issue.
If Excel is maximized on my monitor - if I'm anything less than full screen, I can expand without issue.
If I'm on my primary monitor - if I drag excel over to my second monitor, I can expand/regroup without any issue, whether maximized or not.

I've never had this issue with any other workbook, and I'm completely stumped since it's such a narrow set of circumstances that causes this -- however, this set of circumstances is how I use excel and the sheet 99% of the time, so it's a big problem for me!