Group Problem

MattB · Apr 19th, 2002, 07:32 AM

After subtotaling my data, I cannot seem to open up the groups using the numbered buttons. I'm getting an error message saying 'cannot shift objects off sheet'.
I can expand & condense the groups individually, but I need numbered group buttons to work.
What's happening!?

MattB · Apr 19th, 2002, 07:55 AM

Problem solved.
I had a comment in one of the cells and it didn't seem to like it. Be aware!

Chris Davison · Apr 19th, 2002, 01:46 PM

that's weird......

was it right down the end of the 65,000 rows or very right over by column IV or something ?

I thought grouping "hid" as oppose to "inserted" rows and columns....!

As Jack maintains, Excel is as enigmatic as the female of the species

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 19th, 2002, 07:32 AM	#1
MattB Board Regular Join Date: Mar 2002 Posts: 62	After subtotaling my data, I cannot seem to open up the groups using the numbered buttons. I'm getting an error message saying 'cannot shift objects off sheet'. I can expand & condense the groups individually, but I need numbered group buttons to work. What's happening!?

Apr 19th, 2002, 07:55 AM	#2
MattB Board Regular Join Date: Mar 2002 Posts: 62	Problem solved. I had a comment in one of the cells and it didn't seem to like it. Be aware!

Apr 19th, 2002, 01:46 PM	#3
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	that's weird...... was it right down the end of the 65,000 rows or very right over by column IV or something ? I thought grouping "hid" as oppose to "inserted" rows and columns....! As Jack maintains, Excel is as enigmatic as the female of the species