View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default Why does "cannot shift objects off sheet" appear when I try to in.

hi
either....
1. you have data in the last row of your sheet
or
2. excel has lost it's reference to used range.

check this site out on how to reset your used range and delete unneeded data.
http://www.contextures.com/xlfaqApp.html#Unused

regards
FSt1

"ramach53" wrote:

Tjhis is a file that I ju moved from 2003. When i attempt to insert a row, I
get the error message "cannot shift objects off sheet". Does anyone know why?