Subtotal error to expand Outline Levels
 

I am able to arrange my data with subtotals and they group effectively into
outline levels. I can also expand and collapse each grouping by clicking
individual "+" and "-" signs. However, when I click "1", "2", or "3" to
collapse the groupings of the outline levels, I get an error message. The
error reads "cannot shift objects off sheet". My sheet is over 44000 rows.
Why is this happening? Is the number of rows a factor?

Please help. It takes quite a long time to expand each level manually with
the plus and minus signs.

Thanks,
Michelle
YVR Airport Authority

Subtotal error to expand Outline Levels
 

Maybe...

XL: "Cannot Shift Objects Off Sheet" Error Hiding Columns
http://support.microsoft.com/default...b;en-ca;211769

Remember to look for comments and merged cells.



Michelle wrote:

I am able to arrange my data with subtotals and they group effectively into
outline levels. I can also expand and collapse each grouping by clicking
individual "+" and "-" signs. However, when I click "1", "2", or "3" to
collapse the groupings of the outline levels, I get an error message. The
error reads "cannot shift objects off sheet". My sheet is over 44000 rows.
Why is this happening? Is the number of rows a factor?

Please help. It takes quite a long time to expand each level manually with
the plus and minus signs.

Thanks,
Michelle
YVR Airport Authority

--

Dave Peterson