Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why does "cannot shift objects off sheet" prevent row insertion?
I am unable to insert rows in an existing spreadheet and a new one I just
initiated in a book with multiple sheets. What did I do to cause this and how do I make it go away? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why does "cannot shift objects off sheet" prevent row insertion?
If there is something in row 65535 you can not insert a row as that would
expect the data to move to row 65536 which doen't exist in Excel (except 2007, I believe). Hit Ctrl & End to move to the last used row/column and see what's there. Ian "Idaho old guy" <Idaho old wrote in message ... I am unable to insert rows in an existing spreadheet and a new one I just initiated in a book with multiple sheets. What did I do to cause this and how do I make it go away? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why does "cannot shift objects off sheet" prevent row insertion?
hi
excel is confused. it's internal reference to used space is off. not to worry. it happen now and then. to correct.... select all unused columns to the right of your data and delete select all unused rows below your data and delete. that should reset everything. Regards FSt1 "Idaho old guy" wrote: I am unable to insert rows in an existing spreadheet and a new one I just initiated in a book with multiple sheets. What did I do to cause this and how do I make it go away? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why does "cannot shift objects off sheet" prevent row insertion?
After following FSt1's advice..............save the workbook for the reset to
take place. Gord Dibben MS Excel MVP On Sat, 3 Nov 2007 10:38:01 -0700, FSt1 wrote: hi excel is confused. it's internal reference to used space is off. not to worry. it happen now and then. to correct.... select all unused columns to the right of your data and delete select all unused rows below your data and delete. that should reset everything. Regards FSt1 "Idaho old guy" wrote: I am unable to insert rows in an existing spreadheet and a new one I just initiated in a book with multiple sheets. What did I do to cause this and how do I make it go away? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why does "cannot shift objects off sheet" prevent row insertio
Thank you. I did that and have no change. It still says cannot shift items
off sheet. This is excel 07 if that makes a difference. "Gord Dibben" wrote: After following FSt1's advice..............save the workbook for the reset to take place. Gord Dibben MS Excel MVP On Sat, 3 Nov 2007 10:38:01 -0700, FSt1 wrote: hi excel is confused. it's internal reference to used space is off. not to worry. it happen now and then. to correct.... select all unused columns to the right of your data and delete select all unused rows below your data and delete. that should reset everything. Regards FSt1 "Idaho old guy" wrote: I am unable to insert rows in an existing spreadheet and a new one I just initiated in a book with multiple sheets. What did I do to cause this and how do I make it go away? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why does "cannot shift objects off sheet" prevent row insertio
There is nothing at the end.
"Ian" wrote: If there is something in row 65535 you can not insert a row as that would expect the data to move to row 65536 which doen't exist in Excel (except 2007, I believe). Hit Ctrl & End to move to the last used row/column and see what's there. Ian "Idaho old guy" <Idaho old wrote in message ... I am unable to insert rows in an existing spreadheet and a new one I just initiated in a book with multiple sheets. What did I do to cause this and how do I make it go away? |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why does "cannot shift objects off sheet" prevent row insertio
hi again,
the advice i gave along with gord's advice(which i forgot) always worked for me but in 2003 back. I don't have 2007, haven't worked with it so i don't know. You may need to seek out a 2007 expert on this one. sorry FSt1 "Idaho old guy" wrote: Thank you. I did that and have no change. It still says cannot shift items off sheet. This is excel 07 if that makes a difference. "Gord Dibben" wrote: After following FSt1's advice..............save the workbook for the reset to take place. Gord Dibben MS Excel MVP On Sat, 3 Nov 2007 10:38:01 -0700, FSt1 wrote: hi excel is confused. it's internal reference to used space is off. not to worry. it happen now and then. to correct.... select all unused columns to the right of your data and delete select all unused rows below your data and delete. that should reset everything. Regards FSt1 "Idaho old guy" wrote: I am unable to insert rows in an existing spreadheet and a new one I just initiated in a book with multiple sheets. What did I do to cause this and how do I make it go away? |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why does "cannot shift objects off sheet" prevent row insertio
Thank you I will keep it posted
"FSt1" wrote: hi again, the advice i gave along with gord's advice(which i forgot) always worked for me but in 2003 back. I don't have 2007, haven't worked with it so i don't know. You may need to seek out a 2007 expert on this one. sorry FSt1 "Idaho old guy" wrote: Thank you. I did that and have no change. It still says cannot shift items off sheet. This is excel 07 if that makes a difference. "Gord Dibben" wrote: After following FSt1's advice..............save the workbook for the reset to take place. Gord Dibben MS Excel MVP On Sat, 3 Nov 2007 10:38:01 -0700, FSt1 wrote: hi excel is confused. it's internal reference to used space is off. not to worry. it happen now and then. to correct.... select all unused columns to the right of your data and delete select all unused rows below your data and delete. that should reset everything. Regards FSt1 "Idaho old guy" wrote: I am unable to insert rows in an existing spreadheet and a new one I just initiated in a book with multiple sheets. What did I do to cause this and how do I make it go away? |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why does "cannot shift objects off sheet" prevent row insertion?
Maybe...
XL: "Cannot Shift Objects Off Sheet" Error Hiding Columns http://support.microsoft.com/default...b;en-ca;211769 Remember to look for comments and merged cells. Idaho old guy wrote: I am unable to insert rows in an existing spreadheet and a new one I just initiated in a book with multiple sheets. What did I do to cause this and how do I make it go away? -- Dave Peterson |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why does "cannot shift objects off sheet" prevent row insertio
Thank you. There are no comments in the sheet, no merged or hidden cells
either. Pre 07 auditing checked for phantom sheet errors (though I don't remember exactly how to get there) I do not seem to find that option in 07. I have checked for links, charts, etc. none exist. "Dave Peterson" wrote: Maybe... XL: "Cannot Shift Objects Off Sheet" Error Hiding Columns http://support.microsoft.com/default...b;en-ca;211769 Remember to look for comments and merged cells. Idaho old guy wrote: I am unable to insert rows in an existing spreadheet and a new one I just initiated in a book with multiple sheets. What did I do to cause this and how do I make it go away? -- Dave Peterson |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why does "cannot shift objects off sheet" prevent row insertio
Where does Ctrl & End take you to?
Ian "Idaho old guy" wrote in message ... There is nothing at the end. "Ian" wrote: If there is something in row 65535 you can not insert a row as that would expect the data to move to row 65536 which doen't exist in Excel (except 2007, I believe). Hit Ctrl & End to move to the last used row/column and see what's there. Ian "Idaho old guy" <Idaho old wrote in message ... I am unable to insert rows in an existing spreadheet and a new one I just initiated in a book with multiple sheets. What did I do to cause this and how do I make it go away? |
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why does "cannot shift objects off sheet" prevent row insertio
Could you have hidden shapes in that worksheet?
Maybe you could run a macro to unhide those shapes: Option Explicit Sub testme() Dim iCtr As Long For iCtr = 1 To ActiveSheet.Shapes.Count ActiveSheet.Shapes(iCtr).Visible = True Next iCtr End Sub Then use F5 (ctrl-g)|Special|Objects and hit the delete key to remove ALL the shapes. Don't do this if there are shapes that should remain hidden or shapes that should not be deleted. Idaho old guy wrote: Thank you. There are no comments in the sheet, no merged or hidden cells either. Pre 07 auditing checked for phantom sheet errors (though I don't remember exactly how to get there) I do not seem to find that option in 07. I have checked for links, charts, etc. none exist. "Dave Peterson" wrote: Maybe... XL: "Cannot Shift Objects Off Sheet" Error Hiding Columns http://support.microsoft.com/default...b;en-ca;211769 Remember to look for comments and merged cells. Idaho old guy wrote: I am unable to insert rows in an existing spreadheet and a new one I just initiated in a book with multiple sheets. What did I do to cause this and how do I make it go away? -- Dave Peterson -- Dave Peterson |
#13
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why does "cannot shift objects off sheet" prevent row insertio
Be sure to "Delete Selected Columns" and "Delete Selected Rows". Simply
clearing cell contents with the Delete key will *not* do what you need. Then save workbook & reopen. -- HTH, George "Idaho old guy" wrote in message ... Thank you. I did that and have no change. It still says cannot shift items off sheet. This is excel 07 if that makes a difference. "Gord Dibben" wrote: After following FSt1's advice..............save the workbook for the reset to take place. Gord Dibben MS Excel MVP On Sat, 3 Nov 2007 10:38:01 -0700, FSt1 wrote: hi excel is confused. it's internal reference to used space is off. not to worry. it happen now and then. to correct.... select all unused columns to the right of your data and delete select all unused rows below your data and delete. that should reset everything. Regards FSt1 "Idaho old guy" wrote: I am unable to insert rows in an existing spreadheet and a new one I just initiated in a book with multiple sheets. What did I do to cause this and how do I make it go away? |
#14
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why does "cannot shift objects off sheet" prevent row insertion?
Has anyone been able to solve this for you?
I ask only because I have the same problem in Excel 2007 and none of the solutions here solves the problem. This happens on all the sheets in my workbook and I know I do not have any hidden data. "Idaho old guy" wrote: I am unable to insert rows in an existing spreadheet and a new one I just initiated in a book with multiple sheets. What did I do to cause this and how do I make it go away? |
#15
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why does "cannot shift objects off sheet" prevent row insertio
Hello, I too would like an answer to this one or at least a way to get around
it. Can you fool the program into letting you add columns? Any help here would be appreciated. I upgraded from an older version and none of the noted solutions are working. Thanks. Kelly "eperry" wrote: Has anyone been able to solve this for you? I ask only because I have the same problem in Excel 2007 and none of the solutions here solves the problem. This happens on all the sheets in my workbook and I know I do not have any hidden data. "Idaho old guy" wrote: I am unable to insert rows in an existing spreadheet and a new one I just initiated in a book with multiple sheets. What did I do to cause this and how do I make it go away? |
#16
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why does "cannot shift objects off sheet" prevent row insertio
Kelly Girl wrote:
Hello, I too would like an answer to this one or at least a way to get around it. Can you fool the program into letting you add columns? Any help here would be appreciated. I upgraded from an older version and none of the noted solutions are working. Thanks. Kelly "eperry" wrote: Has anyone been able to solve this for you? I ask only because I have the same problem in Excel 2007 and none of the solutions here solves the problem. This happens on all the sheets in my workbook and I know I do not have any hidden data. "Idaho old guy" wrote: I am unable to insert rows in an existing spreadheet and a new one I just initiated in a book with multiple sheets. What did I do to cause this and how do I make it go away? Excel apparently thinks you have data in the last row of your spreadsheet. To check this, type Ctrl-End, which should take you to the last entry of your workbook. One approach is to delete all the rows after where you have placed data. A second approach is to highlight all your data, then copy and paste to another sheet or another workbook. Sorry if these solutions have already been mentioned in other replies. My Thunderbird newsreader only shows this one response and not the full thread. Bill |
#17
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why does "cannot shift objects off sheet" prevent row insertio
I have also had this problem and need to resort to a "work around". However,
when I copy the data in the sheet to another workbook, I lose all my named ranges referred to in the associated macros. Any ideas? "Bill Sharpe" wrote: Kelly Girl wrote: Hello, I too would like an answer to this one or at least a way to get around it. Can you fool the program into letting you add columns? Any help here would be appreciated. I upgraded from an older version and none of the noted solutions are working. Thanks. Kelly "eperry" wrote: Has anyone been able to solve this for you? I ask only because I have the same problem in Excel 2007 and none of the solutions here solves the problem. This happens on all the sheets in my workbook and I know I do not have any hidden data. "Idaho old guy" wrote: I am unable to insert rows in an existing spreadheet and a new one I just initiated in a book with multiple sheets. What did I do to cause this and how do I make it go away? Excel apparently thinks you have data in the last row of your spreadsheet. To check this, type Ctrl-End, which should take you to the last entry of your workbook. One approach is to delete all the rows after where you have placed data. A second approach is to highlight all your data, then copy and paste to another sheet or another workbook. Sorry if these solutions have already been mentioned in other replies. My Thunderbird newsreader only shows this one response and not the full thread. Bill |
#18
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why does "cannot shift objects off sheet" prevent row insertio
See 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) "KimC" wrote in message ... I have also had this problem and need to resort to a "work around". However, when I copy the data in the sheet to another workbook, I lose all my named ranges referred to in the associated macros. Any ideas? "Bill Sharpe" wrote: Kelly Girl wrote: Hello, I too would like an answer to this one or at least a way to get around it. Can you fool the program into letting you add columns? Any help here would be appreciated. I upgraded from an older version and none of the noted solutions are working. Thanks. Kelly "eperry" wrote: Has anyone been able to solve this for you? I ask only because I have the same problem in Excel 2007 and none of the solutions here solves the problem. This happens on all the sheets in my workbook and I know I do not have any hidden data. "Idaho old guy" wrote: I am unable to insert rows in an existing spreadheet and a new one I just initiated in a book with multiple sheets. What did I do to cause this and how do I make it go away? Excel apparently thinks you have data in the last row of your spreadsheet. To check this, type Ctrl-End, which should take you to the last entry of your workbook. One approach is to delete all the rows after where you have placed data. A second approach is to highlight all your data, then copy and paste to another sheet or another workbook. Sorry if these solutions have already been mentioned in other replies. My Thunderbird newsreader only shows this one response and not the full thread. Bill |
#19
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why does "cannot shift objects off sheet" prevent row insertio
Thanks for the reply, Bob. However, the document you referenced was
mentioned earlier in the thread. None of the solutions worked as Kelly Girl and eperry also posted. What I really need is a work around. The problem disappears if I copy my range of used cells to another workbook, but then I lose all my named ranges (about 50) and would like to know if my only option is to recreate all the named ranges in the new workbook. Maybe I'll just bite the bullet and recreate them all. Thanks, again, Kim "Bob Phillips" wrote: See 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) "KimC" wrote in message ... I have also had this problem and need to resort to a "work around". However, when I copy the data in the sheet to another workbook, I lose all my named ranges referred to in the associated macros. Any ideas? "Bill Sharpe" wrote: Kelly Girl wrote: Hello, I too would like an answer to this one or at least a way to get around it. Can you fool the program into letting you add columns? Any help here would be appreciated. I upgraded from an older version and none of the noted solutions are working. Thanks. Kelly "eperry" wrote: Has anyone been able to solve this for you? I ask only because I have the same problem in Excel 2007 and none of the solutions here solves the problem. This happens on all the sheets in my workbook and I know I do not have any hidden data. "Idaho old guy" wrote: I am unable to insert rows in an existing spreadheet and a new one I just initiated in a book with multiple sheets. What did I do to cause this and how do I make it go away? Excel apparently thinks you have data in the last row of your spreadsheet. To check this, type Ctrl-End, which should take you to the last entry of your workbook. One approach is to delete all the rows after where you have placed data. A second approach is to highlight all your data, then copy and paste to another sheet or another workbook. Sorry if these solutions have already been mentioned in other replies. My Thunderbird newsreader only shows this one response and not the full thread. Bill |
#20
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why does "cannot shift objects off sheet" prevent row insertio
Sorry, I wasn't seeing the whole thread the latest message juts popped up in
my reader. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "KimC" wrote in message ... Thanks for the reply, Bob. However, the document you referenced was mentioned earlier in the thread. None of the solutions worked as Kelly Girl and eperry also posted. What I really need is a work around. The problem disappears if I copy my range of used cells to another workbook, but then I lose all my named ranges (about 50) and would like to know if my only option is to recreate all the named ranges in the new workbook. Maybe I'll just bite the bullet and recreate them all. Thanks, again, Kim "Bob Phillips" wrote: See 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) "KimC" wrote in message ... I have also had this problem and need to resort to a "work around". However, when I copy the data in the sheet to another workbook, I lose all my named ranges referred to in the associated macros. Any ideas? "Bill Sharpe" wrote: Kelly Girl wrote: Hello, I too would like an answer to this one or at least a way to get around it. Can you fool the program into letting you add columns? Any help here would be appreciated. I upgraded from an older version and none of the noted solutions are working. Thanks. Kelly "eperry" wrote: Has anyone been able to solve this for you? I ask only because I have the same problem in Excel 2007 and none of the solutions here solves the problem. This happens on all the sheets in my workbook and I know I do not have any hidden data. "Idaho old guy" wrote: I am unable to insert rows in an existing spreadheet and a new one I just initiated in a book with multiple sheets. What did I do to cause this and how do I make it go away? Excel apparently thinks you have data in the last row of your spreadsheet. To check this, type Ctrl-End, which should take you to the last entry of your workbook. One approach is to delete all the rows after where you have placed data. A second approach is to highlight all your data, then copy and paste to another sheet or another workbook. Sorry if these solutions have already been mentioned in other replies. My Thunderbird newsreader only shows this one response and not the full thread. Bill |
#21
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why does "cannot shift objects off sheet" prevent row insertio
Hi everyone,
Try working around this issue (the error message when you try to insert sheets) by electing to show all objects. You can do this by pressing CTRL+6. This setting is located in the Advanced tab in the Excel Options dialog box. Let me know if this works for you. I'm curious. - A "Bob Phillips" wrote: Sorry, I wasn't seeing the whole thread the latest message juts popped up in my reader. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "KimC" wrote in message ... Thanks for the reply, Bob. However, the document you referenced was mentioned earlier in the thread. None of the solutions worked as Kelly Girl and eperry also posted. What I really need is a work around. The problem disappears if I copy my range of used cells to another workbook, but then I lose all my named ranges (about 50) and would like to know if my only option is to recreate all the named ranges in the new workbook. Maybe I'll just bite the bullet and recreate them all. Thanks, again, Kim "Bob Phillips" wrote: See 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) "KimC" wrote in message ... I have also had this problem and need to resort to a "work around". However, when I copy the data in the sheet to another workbook, I lose all my named ranges referred to in the associated macros. Any ideas? "Bill Sharpe" wrote: Kelly Girl wrote: Hello, I too would like an answer to this one or at least a way to get around it. Can you fool the program into letting you add columns? Any help here would be appreciated. I upgraded from an older version and none of the noted solutions are working. Thanks. Kelly "eperry" wrote: Has anyone been able to solve this for you? I ask only because I have the same problem in Excel 2007 and none of the solutions here solves the problem. This happens on all the sheets in my workbook and I know I do not have any hidden data. "Idaho old guy" wrote: I am unable to insert rows in an existing spreadheet and a new one I just initiated in a book with multiple sheets. What did I do to cause this and how do I make it go away? Excel apparently thinks you have data in the last row of your spreadsheet. To check this, type Ctrl-End, which should take you to the last entry of your workbook. One approach is to delete all the rows after where you have placed data. A second approach is to highlight all your data, then copy and paste to another sheet or another workbook. Sorry if these solutions have already been mentioned in other replies. My Thunderbird newsreader only shows this one response and not the full thread. Bill |
#22
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why does "cannot shift objects off sheet" prevent row insertio
This problem was really getting to me but this article sorts it all out
http://office.microsoft.com/en-us/ex...412411033.aspx As a quick fix, try CTRL+6 Cheers Jesper |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"cannot shift objects off sheet" error message, | Excel Discussion (Misc queries) | |||
how do I correct error "Can not shift objects offf sheet" | Excel Discussion (Misc queries) | |||
unable to hide columns -"can not shift objects off sheet" shows | Excel Worksheet Functions | |||
when hiding columns mess: "cannot shift objects off sheet" | Excel Discussion (Misc queries) | |||
Error Message: "Cannot shift objects off sheet." | Excel Discussion (Misc queries) |