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

 

[andycat]

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.

 

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