I'm having a weird problem I can't sort out in Excel 2013. I have a large spreadsheet, and have several groups of rows that I can freeze and unfreeze. (Just one "level" of groupings; that is, no nested grouped rows.)  All works just fine, except...   

I add one more set of grouped rows, with the bottom of the grouping three rows above the split.  I can collapse that group just fine, but then when I try to expand it, it doesn't "push" the split down, like it should; rather, the split stays in place, with the ungrouped rows seeming to expand "past" the split (below it).  And, Excel freezes up and needs to be killed off with the task manager! 

If I just delete all the grouped rows that seem to be causing the issue, I then I still have the grouping just three rows above the split, but it's back to working just fine! That is, expanding any of the groups (that are above the split) pushes the split down, and collapsing them "pulls" the split up.   

Normally I can come up with theories as to what's causing problems (and/or Google to get ideas), but in this case, with Excel just freezing up, I have no idea. 

Any suggestions? 

Thanks - Steve 

• Edited by ssickels Tuesday, August 25, 2015 10:39 PM

Hi Steve,

Based on your description, I tested it in my own environment. Did you get the result as shown in the following figure? But my Excel file didn't crash.

If my understanding is incorrect, I suggest you take a screenshot and provide a sample to our email address:
ibsofc@microsoft.com
Please Note: Please add the URL of the case in the email subject or body.

I'm glad to help and follow up your reply.

Regards,

Emi Zhang
TechNet Community Su

Hi Emi,

Many thanks for the reply!  My issue was with just one level of grouping (vs. nested groups), and no filtering.  

I did send you an email with some screenshots a few minutes ago.  I think it's going to be hard to replicate the problem, but hopefully my screenshots will help.

Regards,

Steve