 |
 |
Excel "Cannot shift objects off sheet" error message
|
|
|
|
|
Senior User
Join Date: Aug 2007
Location: U.K.
Status:
Offline
|
|
No problems until this morning, when I try to insert cells, rows or columns, I get the above error message.
If I open a new worksheet and copy all across, I can insert,
AFAIK I have done nothing to prefs etc
HELP !!
http://support.microsoft.com/kb/211769 does not really help me, so far.
However, Time machine to yesterdays Excel saves the day, so I must have done something without realising it.
All I did do was save as, then sort the saved as version for a small project.
I do not use comments.
Whoops, spoke too soon, older version allowed me to insert, but after saving, would not.
So, my (temporary ?) solution is to open New SS and copy data across, so far, so good.
(Last edited by MacNNUK; Jan 25, 2009 at 02:57 AM.
)
|
|
iMac Intel Core i5, 2.5GHz, 4GB RAM, 500GB 21.5" Monitor 10.7.4.
iMac 17" 2.0ghz Intel Core 2 Duo w 3gb memory (White one) 10.6.8.
Internal 500gb / 160gb plus External 500gb x 2 (2x Time Machine)
|
| |
|
|
|
|
|
|
|
Administrator  Join Date: Apr 2001
Location: San Antonio TX USA
Status:
Offline
|
|
My first inclination would be to think that you had somehow added "something" in each cell all the way across (or down), so that there's "something" that's at the edge of the sheet. I don't know what the cell width/height limitations of Excel 2008 are, but they must be really, really large, and I have no clue how one might accidentally add invisible contents to that many cells, but that's the first working theory I'd go with. To test this, you may want to just mark a kazillion "empty" cells across and below and choose "clear" from the Edit menu, then see if you can insert cells. It's worth a shot.
|
|
Glenn -----
OTR/L, MOT, Tx
|
| |
|
|
|
|
|
|
|
Clinically Insane
Join Date: Jun 2001
Location: planning a comeback !
Status:
Offline
|
|
Glenn is right.
You must have accidentally put some content in some of the cells far to the right or bottom.
I'm not sure, but it is possible that even some formatting makes Excel believe you have content in those cells.
If nothing else works, copy the "used" portion of your spreadsheet into a brand new spreadsheet, and work from there.
-t
|
|
|
| |
|
|
|
|
|
|
|
Senior User
Join Date: Aug 2007
Location: U.K.
Status:
Offline
|
|
Originally Posted by turtle777 
Glenn is right.
You must have accidentally put some content in some of the cells far to the right or bottom.
I'm not sure, but it is possible that even some formatting makes Excel believe you have content in those cells.
If nothing else works, copy the "used" portion of your spreadsheet into a brand new spreadsheet, and work from there.
-t
I couldn't find any such content, my get around, as you suggest, of copying and pasting seems to be working.
|
|
iMac Intel Core i5, 2.5GHz, 4GB RAM, 500GB 21.5" Monitor 10.7.4.
iMac 17" 2.0ghz Intel Core 2 Duo w 3gb memory (White one) 10.6.8.
Internal 500gb / 160gb plus External 500gb x 2 (2x Time Machine)
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
 
|
|
|
Forum Rules
|
|
|
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
|
HTML code is Off
|
|
|
|
|
|
|
|
|
|
|
|
|
Top
