Insert column

That error message fires when there is an object (shape, chart, picture,
etc.) that has the "move and size with cells" object positioning property
set and it's anchored to a cell that would be pushed off the page if you do
your column insertion.

You may be able to figure out which object is preventing the insertion by
selecting an existing object on the sheet (or creating a new shape) and
using TAB to cycle through the objects on the sheet.

Todd Aton, SDET
Macintosh Business Unit
Microsoft Corporation

This posting is provided ³AS IS² with no warranties, and confers no rights.



On 2/3/08 5:15 AM, in article
jemcgimpsey-59FBEF.06155003022008 DeleteThis @news.microsoft.com, "JE McGimpsey"
<jemcgimpsey DeleteThis @mvps.org> wrote:

> In article <C3CBA1C8.D274%holtynq@mac.com>, John Holt <holtynq DeleteThis @mac.com>
> wrote:
>
>> Whenever I try to insert a new column in Excel "08 I get the following
>> advice"Cannot shift objects off sheet."
>> Can anyone throw any light on this for me??
>
> Does this happen with every worksheet/workbook or just this one?
>
> Are you working in Compatibility mode (i.e., a .xls file)?
>
> Do you have hidden columns/rows?
>
> Do you have comments or any other objects in the sheet?
 >> Stay informed about: Insert column 

Hi - I'm having the same problem, and this doesn't seem to solve it. As far as I can tell, I don't have any "objects" - just numbers and text.

I have tried this in both compatibility mode and in xlsx mode - and this does not happen in all worksheets - just this one. (Although when I cut and paste all the data from here into a new worksheet the problem persists.)

Thanks for any help!
 >> Stay informed about: Insert column 

Hi - I am also having the same problem. Tried deleting all the columns and rows outside the affected area. Mine is just a simple text and numbers sheet nothing fancy.
Interesting the objects and shapes are grayed out as well. I have tried both modes (xls and xlsx) Even jammed the spreadsheet and would not click in a cell, had to reboot the computer. This issue has rendered Excel unusable not sure what to do now?

Any further ideas from the experts out there?
Many thanks...
 >> Stay informed about: Insert column 

In article <ee8bdb6.3.RemoveThis@webcrossing.caR9absDaxw>,
Discover <arcadia.holdings.RemoveThis@clear.net.nz> wrote:

> Hi - I am also having the same problem. Tried deleting all the columns and
> rows outside the affected area. Mine is just a simple text and numbers sheet
> nothing fancy.
> Interesting the objects and shapes are grayed out as well. I have tried both
> modes (xls and xlsx) Even jammed the spreadsheet and would not click in a
> cell, had to reboot the computer. This issue has rendered Excel unusable not
> sure what to do now?

First, was the sheet/workbook protected?

I have no idea what "Even jammed the spreadsheet" means, but are you
saying you couldn't even Quit, or Force Quit XL?

I'd try, with XL closed, deleting the

com.microsoft.Excel.plist

file in the

~:Library:Preferences

folder (where ~ is your home directory).
 >> Stay informed about: Insert column 

I also get the "Cannot shift objects off sheet." error message.

> > Whenever I try to insert a new column in Excel "08 I get the following
> > advice"Cannot shift objects off sheet."
> > Can anyone throw any light on this for me??
>
> Does this happen with every worksheet/workbook or just this one?
>
just this one
> Are you working in Compatibility mode (i.e., a .xls file)?
>
not that I know of
> Do you have hidden columns/rows?
>
no
> Do you have comments or any other objects in the sheet?
>
none.

I also tried removing the
com.microsoft.Excel.plist

file in the

~:Library:Preferences

no luck. very annoying. Guess i'll go back to Microsoft Office X
for now.

Batch
 >> Stay informed about: Insert column