Archive of Mr Excel Message Board

Back to Errors in Excel archive index
Back to archive home

Collapsing grouped columns - "Cannot shift objects off the sheet" Error

Posted by Ross Petherick on July 31, 2001 8:41 AM

I have a LARGE spreadsheet with a lot of grouping on the columns, however I have run into problems in that if I try to view just at level 1, it gives the error "cannot shift objects off the sheet."

It then "collapses" as many groupings as it thinks it can, and gives up. The sheet I am running contains lots of sensitive data, which I want to be able hide away before I print, but easily access whenever I need to change it.

Any suggestions as to what is causing this, and if there is a bug fix to get round it.

Re: Collapsing grouped columns - "Cannot shift objects off the sheet" Error

Posted by Mark W. on July 31, 2001 8:55 AM

Are you using cell comments? If so, take a look at...

http://support.microsoft.com/support/kb/articles/Q170/0/81.ASP?LN=EN-US&SD=gn&FR=0&qry=Cannot%20shift%20objects%20off%20the&rnk=1&src=DHCS_MSPSS_gn_SRCH&SPR=XLW97

Also...

Posted by Mark W. on July 31, 2001 9:02 AM

See http://support.microsoft.com/support/kb/articles/Q167/3/88.ASP?LN=EN-US&SD=gn&FR=0&qry=autocorrect&rnk=9&src=DHCS_MSPSS_gn_SRCH&SPR=XLW97

Oops! Misplaced Posting...

Posted by Mark W. on July 31, 2001 9:13 AM

What if you're not using comments?

Posted by Peter Alessandri on August 01, 2001 9:37 AM

Don't know

Posted by Mark W. on August 01, 2001 11:34 AM

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.