Expanding a set of grouped rows causing excel to freeze/crash

%3CLINGO-SUB%20id%3D%22lingo-sub-1921073%22%20slang%3D%22en-US%22%3EExpanding%20a%20set%20of%20grouped%20rows%20causing%20excel%20to%20freeze%2Fcrash%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1921073%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20one%20of%20my%20workbook%20sheets%2C%20I%20have%20a%20section%20of%20about%2010%20rows%20that%20I've%20grouped%20together.%20When%20I%20go%20to%20ungroup%20the%20rows%20using%20the%20%22%2B%22%20sign%2C%20it%20freezes%20Excel%20--%20BUT%2C%20it%20only%20freezes%20if%20I'm%20scrolled%20all%20the%20way%20over%20to%20the%20left%20of%20the%20sheet%2C%20and%20if%20Excel%20is%20maximized%20on%20my%20monitor%2C%20and%20I'm%20on%20my%20primary%20monitor.%20If%20any%20of%20these%20conditions%20is%20not%20met%2C%20the%20sheet%20works%20fine%20(i.e.%2C%20if%20I'm%20even%20one%20column%20over%20--%20not%20showing%20column%20A%2C%20or%20if%20I%20move%20Excel%20over%20to%20my%20second%20monitor%2C%20I%20can%20expand%20the%20group%20with%20no%20issues).%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20never%20had%20this%20issue%20with%20any%20other%20workbook%2C%20and%20I'm%20completely%20stumped%20since%20it's%20such%20a%20narrow%20set%20of%20circumstances%20that%20causes%20this%20--%20however%2C%20this%20set%20of%20circumstances%20is%20how%20I%20use%20excel%20and%20the%20sheet%2099%25%20of%20the%20time%2C%20so%20it's%20a%20big%20problem%20for%20me!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1921073%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1921405%22%20slang%3D%22de-DE%22%3ESubject%3A%20Expanding%20a%20set%20of%20grouped%20rows%20causing%20excel%20to%20freeze%2Fcrash%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1921405%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F877469%22%20target%3D%22_blank%22%3E%40akoo371%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWith%20your%20permission%2C%20if%20I%20can%20recommend%20you%2C%20add%20a%20file%20(without%20sensitive%20data)%20to%20your%20project.%3C%2FP%3E%3CP%3EIt%20is%20much%20easier%20for%20someone%20who%20wants%20to%20help%20understand%20the%20subject.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20no%20Picture%2C%20even%20if%20it%20is%20said%20that%20a%20picture%20can%20say%20a%20thousand%20words%2C%20it%20is%20certainly%20not%20in%20the%20case%20of%20Excel%2C%20on%20the%20contrary%20in%20some%20cases%2C%20like%20this%20case%20%3A).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%20Knowing%20the%20Excel%20version%20and%20operating%20system%20would%20be%20an%20advantage.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1921841%22%20slang%3D%22en-US%22%3EBetreff%3A%20Expanding%20a%20set%20of%20grouped%20rows%20causing%20excel%20to%20freeze%2Fcrash%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1921841%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722750%22%20target%3D%22_blank%22%3E%40Nikolino%3C%2FA%3E%26nbsp%3BThanks%20for%20your%20response.%20I've%20included%20an%20example.%20Recap%20of%20my%20problem%3A%20when%20i%20have%20the%20attached%20sheet%20open%2C%20fill%20my%20primary%20monitor%20with%20Excel%2C%20scroll%20all%20the%20way%20to%20the%20left%20of%20the%20%22Grouping%20Issue%22%20tab%2C%20a%3CSTRONG%3End%20then%20click%20on%20the%20%2B%20sign%20on%20row%2022%20to%20expand%20the%20grouped%20rows%2C%20Excel%20freezes%20up.%26nbsp%3B%3C%2FSTRONG%3EIf%20I%20change%20one%20little%20thing%20about%20those%20conditions%20(i.e.%20open%20on%20second%20monitor%2C%20or%20not%20maximize%20the%20sheet%20on%20my%20primary%20monitor)%2C%20I%20have%20no%20issues.%20It's%20a%20very%20strange%20set%20of%20circumstances%2C%20so%20i'm%20not%20sure%20if%20you%20will%20be%20able%20to%20replicate%20the%20problem%20on%20your%20computer.%20Thanks%20again%20for%20any%20help%20you%20can%20provide.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1921939%22%20slang%3D%22de-DE%22%3ESubject%3A%20Expanding%20a%20set%20of%20grouped%20rows%20causing%20excel%20to%20freeze%2Fcrash%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1921939%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F877469%22%20target%3D%22_blank%22%3E%40akoo371%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EI%20can't%20replicate%20it%20to%20myself.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EIs%20the%20VBA%20code%20in%20the%20%22Assumptions%22%20worksheet%20wanted%3F%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3Efade%20in%20and%20fade%20out%20is%20also%20possible%20manually.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EHave%20you%20downloaded%20the%20latest%20video%20driver%20version%3F%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EWith%20Windows%20Update%2C%20some%20PCs%20are%20very%20sensitive%2C%20although%20the%20PC%20manufacturers%20should%20have%20solved%20these%20problems%20long%20ago%2C%20it%20happens%20now%20and%20then%20that%20after%20a%20Windows%20update%2C%20some%20PCs%20behaveally%20problematic%20(would%20rather%20not%20mention%20any%20brands%20in%20a%20public%20forum%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EWhich%20version%20of%20Excel%20and%20operating%20system%20do%20you%20have%3F%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESorry%20that%20I%20took%20your%20time%20and%20couldn't%20give%20you%20a%20quick%20solution.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWish%20you%20a%20nice%20day.%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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 all the way over to the left of the sheet, and if Excel is maximized on my monitor, and I'm on my primary monitor. If any of these conditions is not met, the sheet works fine (i.e., if I'm even one column over -- not showing column A, or if I move Excel over to my second monitor, I can expand the group with no issues). 

 

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!

4 Replies

@akoo371 

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)

@Nikolino 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. 

@akoo371 

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)

 

 

@Nikolino 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!