Can't insert rows - "Cannot shift object off sheet"

[Denis]

I am using Excel 2007 and have just loaded a spreadsheet created in a
previous version which is running in Compatibility mode. When I try to
insert a row I get an message "Cannot shift objects off sheet".

How do I insert rows on this sheet? No problem with another workbook loaded
at the same time which was created in 2007.

 

[Bob Phillips]

See if this helps

http://support.microsoft.com/default.aspx?kbid=211769
"Cannot shift objects off sheet" error message when you hide columns in
Excel


--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Phil James]

The macro and other help at the referenced page only work if there are hidden objects. So far, the only method that has worked it to copy the sheet or sheets to a new workbook in 2007 to insert the columns or rows.

 

[Shane Devenshire]

?? - where's the rest of this thread?

in message news:[email protected]...

 

[chandramoulikr]

I am using Excel 2007 and have just loaded a spreadsheet created in a
previous version which is running in Compatibility mode. When I try to
insert a row I get an message "Cannot shift objects off sheet".

How do I insert rows on this sheet? No problem with another workbook loaded
at the same time which was created in 2007.