Can't Insert A Row

[David]

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

 

[Bob I]

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.

 

[David]

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".

 

[Bob I]

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

 

[David]

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.

 

[Bob I]

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

 

[eheikkila]

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





- 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.