 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / May 2008Can't insert rows - "Cannot shift object off sheet"
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. 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  Signature--- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) >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. 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. ?? - where's the rest of this thread? > 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.
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.