Outlining error "Cannot shift objects off sheet"

  • Thread starter Thread starter Carlsongoblue
  • Start date Start date
C

Carlsongoblue

I have been using the grouping and outlining feature to group data sets so
that users can expand on only the areas in which they are interested. I have
15 groups of columns in a row. I currently have 12 of them closed and excel
will not let me close down any more. It is giving me the following error:

"Cannot shfit objects off sheet"

It doesn't seem to matter which 12 I have closed. If I open up a closed
grouping, I am able to close down another one. (hope that makes sense) I am
going bananas here - does anyone know why I am getting this error?

I am using Excel 2003 on XP Pro.

Any suggestions?
 
Back
Top