Why does "cannot shift objects off sheet" prevent row insertion?

[AnnelieseW]

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

 

[Jesper Audi]

This problem was really getting to me but this article sorts it all out

http://office.microsoft.com/en-us/excel/HA102412411033.aspx

As a quick fix, try CTRL+6

Cheers Jesper