BigJohnDiddy
asked on
Excel 2007: System Crashes Whilst Trying to Group Data...
Hi Experts,
Please view the attached file. I've never come across this before! If I attempt to "Auto Outline" or "Group" data on this worksheet, Excel 2007 hangs so I need to end process using task manager.
in the worksheet attached, I wish to group the following rows:
a) 6 - 15
b) 18 - 52
and the following columns:
c) F - Q
Questions:
1) Can anyone else group the file?
2) Has anyone come across this issue before?
3) Are there any workarounds?
Thanks for your help!
John Diddy
Grouping-Issues.xlsx
Please view the attached file. I've never come across this before! If I attempt to "Auto Outline" or "Group" data on this worksheet, Excel 2007 hangs so I need to end process using task manager.
in the worksheet attached, I wish to group the following rows:
a) 6 - 15
b) 18 - 52
and the following columns:
c) F - Q
Questions:
1) Can anyone else group the file?
2) Has anyone come across this issue before?
3) Are there any workarounds?
Thanks for your help!
John Diddy
Grouping-Issues.xlsx
ASKER
Hi Teylyn,
I copied this worksheet from another spreadsheet, and it has exactly the same problems. I therefore assume that the problem isn't to do with the physical file itself.
However, I have absolutely no idea what formula I'm using that's causing Excel 2007 to crash out when I try to the outline tool!
Annoying!
I copied this worksheet from another spreadsheet, and it has exactly the same problems. I therefore assume that the problem isn't to do with the physical file itself.
However, I have absolutely no idea what formula I'm using that's causing Excel 2007 to crash out when I try to the outline tool!
Annoying!
Try running this macro, then group:
Sub Fixit()
With Range("A76:A" & Rows.Count)
.RowHeight = 12.5
.EntireRow.Hidden = True
End With
End Sub
ASKER
Hi Rorya,
The fix worked! Thanks for your help!!! Following on from your code, I realised that grouping will work if there are no hidden rows and columns on this sheet.
Can you please give me a bit of feedback as to why your macro works?
Cheers,
John Diddy
The fix worked! Thanks for your help!!! Following on from your code, I realised that grouping will work if there are no hidden rows and columns on this sheet.
Can you please give me a bit of feedback as to why your macro works?
Cheers,
John Diddy
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
@ Rorya,
Thanks for that! I assumed hidden rows because at no point would I set multiple rows to a very, very, very small number! Do you have any idea where the shrunken rows come from in the first place?
Thanks for that! I assumed hidden rows because at no point would I set multiple rows to a very, very, very small number! Do you have any idea where the shrunken rows come from in the first place?
Not a clue - some people do that deliberately so that you can't unhide them; others do it by accident. If it's your workbook, you would know better than I how it got that way! ;)
BigJohnDiddy said:
>> Do you have any idea where the shrunken rows come from in the first place?
Somebody selected all rows below row 75 and set the row height to zero. Who'd have thunk that it affects grouping?!?
>> Do you have any idea where the shrunken rows come from in the first place?
Somebody selected all rows below row 75 and set the row height to zero. Who'd have thunk that it affects grouping?!?
You can re-set the rows to normal height manually, too. Click the last visible row header, then Ctrl-Shift-down, then click Format - Rows - Row Height - Autosize. Then hide them if you don't want to see them.
FYI, setting the height to zero should not prevent you from unhiding the rows - it only works if you set it to a small positive number like 0.75.
Interesting! I opened the file and hit F5 - A88 and then went Format - Row - Row height and it showed 0 as the row height. Does that mean that the Row height dialog is using some kind of rounding?
Yes - as far as I know it only goes in quarters.
Sonobaditch!
Sohn des schlechten Krätze? :)
so ungefähr! :-)
Was 'des' right?
Should have been 'der' since Krätze is feminin (go figure, 'der' for the feminine, ah well), but who understands Genitiv these days, anyway?
Genitiv ins Wasser! - Wieso? Ist denn das Wasser Dativ?
Genitiv ins Wasser! - Wieso? Ist denn das Wasser Dativ?
And they say Germans have no sense of humour... 8^D
(I think it's funny, anyway)
(I think it's funny, anyway)
ASKER
Be wary of very, very small dimensions! Little buggers in every sense of the phrase! ')
ASKER
Experts
To be honest, I have absolutely no reason to set the row heights to zero or 0.75 etc...!
So what could possibly have caused this to happen? All i do is hide rows!!!
John Diddy
To be honest, I have absolutely no reason to set the row heights to zero or 0.75 etc...!
So what could possibly have caused this to happen? All i do is hide rows!!!
John Diddy
As soon as I try to group rows 5 to 15, my Excel 2010 hangs ... There's probably something wrong with the file, though I can't figure out what.