Can't Insert A Row

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

David - 25 Jul 2007 20:10 GMT

I running Excel 2007 on a Win/XP Pro SP2 workstation. I have a
spreadsheet I have been using for quite some time. Its saved as a
'xls' file, not 'xlsx'.

Periodically, I add more data into one of the sheets - I have about 8
tabs. This requires inserting a row. I do this via Home => (Cell
Menu) Insert => Insert sheet rows. I've always clicked on the row
number, then on Insert Sheet Rows.

Today, it won't work. I get a nasty gram "Can Not Shift Objects Off
Sheet".

The same procedure will insert rows on other xls files.

I'd appreciate any help offered.

Dave

Reply to this Message

Bob I - 25 Jul 2007 20:34 GMT

Review what's on the bottom row of the sheet. If nothing appears to be
there simple select the last few rows and delete them, then go back and
try insert.

> I running Excel 2007 on a Win/XP Pro SP2 workstation. I have a
> spreadsheet I have been using for quite some time. Its saved as a
[quoted text clipped - 13 lines]
>
> Dave

Reply to this Message

David - 25 Jul 2007 21:06 GMT

The printable area on each tab does not include everything I have
entered into the sheet. Never the less, I went to the first "blank"
row after the last row of info I entered. I deleted that row & a
bunch more. I did this on each tab. This did not solve the problem.
I also tried deleting the bottom 10 rows from the individual tabs.
This did not help either.

I have a 2nd PC - a Win/2K laptop with Office 2000. I copied the
entire xls file off my workstation onto a USB flash drive. I put the
flash drive into the Win/2K laptop with Office 2K. I was able then to
insert the rows I desired into the xls file. I put the flash drive
back in my workstation. Excel 2007 readily opened the file. The
inserted rows were there. But, Excel 2007 will not add any more rows.
I get the same popup screen with: "Can Not Shift Objects Off
Sheet".

>Review what's on the bottom row of the sheet. If nothing appears to be
>there simple select the last few rows and delete them, then go back and
[quoted text clipped - 17 lines]
>>
>> Dave

Reply to this Message

andycat - 26 Jul 2007 05:51 GMT

Do all the rows contain formatted cells? For instance, cell shading? Even
if there is no data in the cells, the formatting could be the issue. If so,
try unformatting the cells on unused rows, then inserting new rows.

> The printable area on each tab does not include everything I have
> entered into the sheet. Never the less, I went to the first "blank"
[quoted text clipped - 33 lines]
>>>
>>> Dave

Reply to this Message

Bob I - 26 Jul 2007 15:55 GMT

Maybe someone with 2007 can crosscheck/replicate this, but it sounds
like a bug in the "2003 compatibility" side of 2007.

> The printable area on each tab does not include everything I have
> entered into the sheet. Never the less, I went to the first "blank"
[quoted text clipped - 33 lines]
>>>
>>>Dave

Reply to this Message

David - 26 Jul 2007 19:00 GMT

I have tried converting the xls file to xlsx (an Excel 2007) file
using the "Save As" function. This did not help either. Is there any
possibility I've screwed up a setting or option somewhere that has
caused this problem? I thought trying this might get around the bug
you mentioned was a possibility.

>Maybe someone with 2007 can crosscheck/replicate this, but it sounds
>like a bug in the "2003 compatibility" side of 2007.
[quoted text clipped - 36 lines]
>>>>
>>>>Dave

Reply to this Message

Bob I - 26 Jul 2007 19:19 GMT

Doesn't make sense to me, but it sounds like it is only 2007 that has
the issue.

> I have tried converting the xls file to xlsx (an Excel 2007) file
> using the "Save As" function. This did not help either. Is there any
[quoted text clipped - 42 lines]
>>>>>
>>>>>Dave

Reply to this Message

eheikkila@gmail.com - 28 Aug 2007 21:55 GMT

> Doesn't make sense to me, but it sounds like it is only2007that has
> the issue.
[quoted text clipped - 47 lines]
>
> - Show quoted text -

After talking to Microsoft It turned out that the issue was HIdden
Objects for me and the fix was to hit ctrl 6 to show all objects. This
was not a problem in previous version of Excel, but there seems to be
a bug in office 2007 that locks objects.

Reply to this Message

Rate this thread: