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.
Thanks - Steve
- Edited by ssickels Tuesday, August 25, 2015 10:39 PM