excell 2007-insert row- "problem"

B

basicgerm

Member
Joined
Jan 28, 2009
Messages
18
Reaction score
0
hi, sorry about this mediocre question, i've recently changed one of the pc's we use to work to use the MS Office 2007 while others are still on 2003 just so we can migrate slowly to 2007 version. currently having this one problem of "insert row". it gives me the problem: "CANNOT SHIFT OBJECTS OFF SHEET". and the only option it gives is OK. this is when i'm working on a worksheet created by excell 2003.

i currently don't have problems with opening and working on the ones created by excell 2007 in excell 2003 as i have downloaded that add on from the microsoft site.

help will be very appreciated
thanx
 
Save it as an xlsx file (The new excel version),
then try to modify it... Might be that the sheet is full to it's max capacity. Excel 2007's max capacity is 2mil lines.
 
Try this..
Open a new spreadsheet, copy everything from the old one into notepad, then copy it all again to the new spreadsheet.
(The note pad step removes anything extra, and just keeps the cell's data)
 
yes sir, that one does work... i was just hoping to minimise the time spent on copy pasting. when i do that, i also need to rearrange the cell alignmetn which is in itself alone time consuming..... is there no settings at all i can enable or disable something to allow me to insert rows? like a restriction or something... this damn thing is a pain....
 
You can also select all the cells, and then paste only the formatting and column widths in a new sheet. Then copy only the data that you want and paste only the values/formula into the new sheet.

I've had a similar problem as well. I think it was caused because I made my border run right down through to the end of the sheet. When you try to insert a row, excel tries to push the bottom rows down, together with it's formatting. So if you have borders/data on the last cells, then it just does not compute.

Hope that helps :-)
 
You must log in or register to reply here.
Back
Top
Sign up to the MyBroadband newsletter
X