Results 1 to 6 of 6
  1. #1
    Star Lounger
    Join Date
    Mar 2002
    Location
    San Jose, California, USA
    Posts
    82
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Cannot shift objects off sheet (Excel 2000)

    I am trying to hide some columns on a spreadsheet and I keep getting the error message "Cannot shift objects off sheet". I don't want to shift them off the sheet, I simply want to hide the columns to make the sheet more readable. Any idea what is causing this message and what I can do to prevent it?
    Sheet runs from columns E to AX. I'm trying to hide columns in the middle of the sheet (N-T).

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Cannot shift objects off sheet (Excel 2000)

    See if <!mskb=211769>Microsoft Knowledge Base Article 211769<!/mskb> helps (thanks to <!profile=sdckapr>sdckapr<!/profile> for digging up this article two weeks ago.)

  3. #3
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Cannot shift objects off sheet (Excel 2000)

    I can reproduce this error message if I have a picture object inserted and try to hide all columns. I guess that you have some kind of object inserted in the sheet and are forcing it to anchor so far to the left or the bottom of the sheet that it's "running out of room". Do you have an object such as a picture or OLE object embedded? See if you can find the object through Edit, Goto, Special Objects.
    -John ... I float in liquid gardens
    UTC -7ąDS

  4. #4
    Star Lounger
    Join Date
    Mar 2002
    Location
    San Jose, California, USA
    Posts
    82
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Re: Cannot shift objects off sheet (Excel 2000)

    Well - it seems to work, but very inconsistantly. I have removed all comments from the sheet. Lets say I want to hide columns N-U. If I select them all I still get the error message. If I start hiding individual columns, starting at N I can get as far as S before I get the error. Starting at the other end, I can again hide 5 columns U,T,S,R,Q, but on the 6th one (P this time) I get the error again. If I select a block of columns to hide I can only hide 4 together before I get the error.

    This is too weird!

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Cannot shift objects off sheet (Excel 2000)

    Could you post a small workbook in which the problem occurs (just one worksheet, remove data as much as possible without removing the problem, delete or modify sensitive data)? That would enable Loungers to investigate the problem.

  6. #6
    Star Lounger
    Join Date
    Mar 2002
    Location
    San Jose, California, USA
    Posts
    82
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Re: Cannot shift objects off sheet (Excel 2000)

    Problem Solved! Finally discovered some hidden columns off to the right on the sheet (It stopped at BN and I couldn't work out how to unhide the rest - but now I have - "Format/Columns/Unhide") Guess what? there was some additional data with comments. Deleted that and all is now working as expected.

    Question is? Will Micro$oft fix the Excel bug in later versions? How do you force Excel to insert comments that can scale and move with the cells?

    Thanks for the help.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •