While horizontally grouping (outlining) a set of columns, I receive an error
message that reads "Cannot shift objects off of sheet" when I press the ( - )
to collapse the columns. There are no objects that I am aware of, and the
message does not appear when the last column is ungrouped. Also, it appears
when the previous group is collapsed and visa versa. That is, I can collapse
one group and get the message when I try to collapse the other group. It is
really strange the message pops up at some of the oddest times.

Has anyone encountered this before. Anyone's help would be greatly
appreciated.

Thanks.

Carey

maybe this'll help:

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

(Look for runaway comments!)

carey wrote:

While horizontally grouping (outlining) a set of columns, I receive an error
message that reads "Cannot shift objects off of sheet" when I press the ( - )
to collapse the columns. There are no objects that I am aware of, and the
message does not appear when the last column is ungrouped. Also, it appears
when the previous group is collapsed and visa versa. That is, I can collapse
one group and get the message when I try to collapse the other group. It is
really strange the message pops up at some of the oddest times.

Has anyone encountered this before. Anyone's help would be greatly
appreciated.

Thanks.

Carey

--

Dave Peterson

Dave:

Thanks for the quick response. However, the link did not fully resolve the
problem because there are no objects nor any cell comments. The message shows
up randomly for not reason that I am capable of determining.

For instance, I had created a few groups, open them, then I created new
groups, and was able to collapse the new groups. However, the previously
created groups cannot collapse and I get the same message. It is really go me
baffled.

Carey

"Dave Peterson" wrote:

maybe this'll help:

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

(Look for runaway comments!)

carey wrote:

While horizontally grouping (outlining) a set of columns, I receive an error
message that reads "Cannot shift objects off of sheet" when I press the ( - )
to collapse the columns. There are no objects that I am aware of, and the
message does not appear when the last column is ungrouped. Also, it appears
when the previous group is collapsed and visa versa. That is, I can collapse
one group and get the message when I try to collapse the other group. It is
really strange the message pops up at some of the oddest times.

Has anyone encountered this before. Anyone's help would be greatly
appreciated.

Thanks.

Carey

--

Dave Peterson

As an added note:

I am able to create and collapse groups up to a certain cell in the
worksheet without getting the error message. After that, I get the message
for groups I newly create.

Anyone with any ideas of what is going would be apprecated. I definitely
need help on this one. It has got me going in circles.

Carey

"Dave Peterson" wrote:

maybe this'll help:

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

(Look for runaway comments!)

carey wrote:

While horizontally grouping (outlining) a set of columns, I receive an error
message that reads "Cannot shift objects off of sheet" when I press the ( - )
to collapse the columns. There are no objects that I am aware of, and the
message does not appear when the last column is ungrouped. Also, it appears
when the previous group is collapsed and visa versa. That is, I can collapse
one group and get the message when I try to collapse the other group. It is
really strange the message pops up at some of the oddest times.

Has anyone encountered this before. Anyone's help would be greatly
appreciated.

Thanks.

Carey

--

Dave Peterson

How about
edit|goto|special
check objects.

Did anything get selected?



carey wrote:

As an added note:

I am able to create and collapse groups up to a certain cell in the
worksheet without getting the error message. After that, I get the message
for groups I newly create.

Anyone with any ideas of what is going would be apprecated. I definitely
need help on this one. It has got me going in circles.

Carey

"Dave Peterson" wrote:

maybe this'll help:

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

(Look for runaway comments!)

carey wrote:

While horizontally grouping (outlining) a set of columns, I receive an error
message that reads "Cannot shift objects off of sheet" when I press the ( - )
to collapse the columns. There are no objects that I am aware of, and the
message does not appear when the last column is ungrouped. Also, it appears
when the previous group is collapsed and visa versa. That is, I can collapse
one group and get the message when I try to collapse the other group. It is
really strange the message pops up at some of the oddest times.

Has anyone encountered this before. Anyone's help would be greatly
appreciated.

Thanks.

Carey

--

Dave Peterson


--

Dave Peterson

Nope, nothing was selected or found. The sheets are free of objects and
comments.

I also copy pasted to a new workbook file. That didn't help either. Around
the G? columns I get the messages when recreating the groups.

Any other ideas? This is becoming very frustrating.

Carey

"Dave Peterson" wrote:

How about
edit|goto|special
check objects.

Did anything get selected?



carey wrote:

As an added note:

I am able to create and collapse groups up to a certain cell in the
worksheet without getting the error message. After that, I get the message
for groups I newly create.

Anyone with any ideas of what is going would be apprecated. I definitely
need help on this one. It has got me going in circles.

Carey

"Dave Peterson" wrote:

maybe this'll help:

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

(Look for runaway comments!)

carey wrote:

While horizontally grouping (outlining) a set of columns, I receive an error
message that reads "Cannot shift objects off of sheet" when I press the ( - )
to collapse the columns. There are no objects that I am aware of, and the
message does not appear when the last column is ungrouped. Also, it appears
when the previous group is collapsed and visa versa. That is, I can collapse
one group and get the message when I try to collapse the other group. It is
really strange the message pops up at some of the oddest times.

Has anyone encountered this before. Anyone's help would be greatly
appreciated.

Thanks.

Carey

--

Dave Peterson


--

Dave Peterson

Sorry, I don't have any more guesses.

carey wrote:

Nope, nothing was selected or found. The sheets are free of objects and
comments.

I also copy pasted to a new workbook file. That didn't help either. Around
the G? columns I get the messages when recreating the groups.

Any other ideas? This is becoming very frustrating.

Carey

"Dave Peterson" wrote:

How about
edit|goto|special
check objects.

Did anything get selected?



carey wrote:

As an added note:

I am able to create and collapse groups up to a certain cell in the
worksheet without getting the error message. After that, I get the message
for groups I newly create.

Anyone with any ideas of what is going would be apprecated. I definitely
need help on this one. It has got me going in circles.

Carey

"Dave Peterson" wrote:

maybe this'll help:

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

(Look for runaway comments!)

carey wrote:

While horizontally grouping (outlining) a set of columns, I receive an error
message that reads "Cannot shift objects off of sheet" when I press the ( - )
to collapse the columns. There are no objects that I am aware of, and the
message does not appear when the last column is ungrouped. Also, it appears
when the previous group is collapsed and visa versa. That is, I can collapse
one group and get the message when I try to collapse the other group. It is
really strange the message pops up at some of the oddest times.

Has anyone encountered this before. Anyone's help would be greatly
appreciated.

Thanks.

Carey

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson