Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
"Cannot shift objects off sheet" - what?
Hi,
I have quite a big file (several linked worksheets and charts). I have used group function earlier and grouping has worked fine. Now when I try to open or close group, I get message "Cannot shift objects off sheet". Usually nothing happens, but sometimes it works. I have ungrouped and regrouped. I have saved file as other file. No help. I can't start from scratch. Pls advise. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
"Cannot shift objects off sheet" - what?
I usually get that message when there is data in the last row/column and I
try to insert a row/column. Perhaps verify where your data actually ends and reset the used range. http://contextures.com/xlfaqApp.html#Unused "Tinde" wrote: Hi, I have quite a big file (several linked worksheets and charts). I have used group function earlier and grouping has worked fine. Now when I try to open or close group, I get message "Cannot shift objects off sheet". Usually nothing happens, but sometimes it works. I have ungrouped and regrouped. I have saved file as other file. No help. I can't start from scratch. Pls advise. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
"Cannot shift objects off sheet" - what?
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. Tinde wrote: Hi, I have quite a big file (several linked worksheets and charts). I have used group function earlier and grouping has worked fine. Now when I try to open or close group, I get message "Cannot shift objects off sheet". Usually nothing happens, but sometimes it works. I have ungrouped and regrouped. I have saved file as other file. No help. I can't start from scratch. Pls advise. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"cannot shift objects off sheet" REAL help needed | Excel Discussion (Misc queries) | |||
Excel error "Cannot shift objects off sheet", can I fix? | 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) |