Outlining error "Cannot shift objects off sheet"

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

"cannot shift objects off sheet" error 8
inlineShape.OLEFormat.Activate() command fails for excel file 0
Closing grouping in Excel I get "Cannot shift objects off sheet"? 1
cannot shift objects off sheet 1
Grouping/Outlining in Excel 2003 with Protection turned on 1
Cannot shift objects off sheet 7
Cannot shift objects off sheet? 2
Cannot Shift Objects Off Sheet 0

Top