Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Ankeny, Iowa, USA
    Posts
    344
    Thanks
    8
    Thanked 0 Times in 0 Posts
    Hi,

    Since our company upgraded to Excel 2007 in the last few months I've had 3 occassions where people are trying to insert a row into an old worksheet and get the following message:
    "Cannot shift object off sheet"
    The worksheets were originally created in Excel 2002 or 2003. My original solution was to copy & paste to a new worksheet (which solves the problem for some reason), but the file I'm working with today has many formulas linked everywhere... it could cause a problem to try this. Does anybody know why this is suddenly a problem now that we've upgraded to '07?

    Thanks!
    Lana

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

  3. #3
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Ankeny, Iowa, USA
    Posts
    344
    Thanks
    8
    Thanked 0 Times in 0 Posts
    Problem solved!!! Thanks so much Hans!! It's as simple as pressing Ctrl + 6 to turn off the display objects function.
    Thanks again!
    Lana

Posting Permissions

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