Problem with grouping rows and freezing panes - Excel locks up!
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 8 hours 54 minutes ago
August 25th, 2015 6:34pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics