Expanding Grouped Rows Freezing Excel (w/example workbook)

  • I posted this question yesterday, but wanted to include an example sheet of the issue I'm having. I didn't include one yesterday, because I don't have the issue even when I move the sheet to my second monitor, so I'm not sure if anyone else will be able to duplicate my problem. The problem I have is when I have the attached Excel file opened and filling my primary monitor's screen, and I'm scrolled all the way to the left of the sheet, and then I click to expand the grouped rows using the + sign in row 22 of the "Grouping Issue" tab, it freezes my Excel. Below is my original post from yesterday.



    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!

  • Add the example to the existing question.


    This is a duplicate post and as such does not comply with our forum rules. This thread will now be closed, you may continue in your other thread.


    Thread Closed.

  • royUK

    Closed the thread.