Results 1 to 7 of 7
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Error message (XP)

    Co-worker trying to insert entire row - gets this message:

    Cannot shift objects off sheet.

    ????????????????????

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Error message (XP)

    There might be an object near the bottom of the worksheet. hit F5 (goto), special, objects. Now use the tab key to see which are there. if you find one near the bottom of the sheet, remove it.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Error message (XP)

    "no objects found"

    Sigh . . .

    Didn't say but maybe it matters - the document is password protected . . .

  4. #4
    Bronze Lounger
    Join Date
    Sep 2007
    Posts
    1,203
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Error message (XP)

    I can't really explain why, but try selecting a chunk of blank rows from the bottom of the worksheet and deleting them. I've had this help me out in the past. Though if the sheet is protected, you may need to unprotect first.

  5. #5
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Error message (XP)

    I can't explain it, either - so I just copied all the data and pasted just the values in to a new workbook - works fine. I don't know what the author will do with it - but when I sent it to her, it was working . . .

    Thanks for trying!

    Aunt Linda

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

    Re: Error message (XP)

    It can also be caused by comments attached to cells.

  7. #7
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Error message (XP)

    No comments, either - also deleted all blank rows and columns - the only fix I could find was what I did . . .

    Another mystery of the universe unsolved . . .

    Thanks for trying, though - always appreciate any help I can get.

    Aunt Linda

Posting Permissions

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