View Single Post
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

Maybe you have some objects that get rearranged when you hide the columns using
your grouping symbols.

This may have some suggestions that work for you. It's kind of a similar
problem.

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.

Matt wrote:

I created a command grouping several columns together by going to Data, Group.
When I go to click on the "-" sign to group. It gives me an error
message;"Cannot shift object off sheet". Why? and how can I fix it.


--

Dave Peterson