I am new to Excel2007 although I have been using Excel for many years.

The problem I am having exists with only one Excel workbook file and
only in Excel2007,  The problem exists if I save the file as a 'xlsx'
file or as a 'xls' file.

My problem workbook contains 6 sheets (tabs).  It was originally
created on my old PC using Excel2000 and since transferred to my new
PC which has Excel2007.  The worksheet is essentially a large database
with relatively few calculations.  When I try to insert a row (HOME ->
Cell Menu -> Insert -> Insert Sheet Rows), I get the following nasty
gram:  "Can't shift object off sheet".  The problem also exists with
the same error message if I try to insert a column.

I have already looked at the bottom row.  There is no garbage in it. I
have tried deleting all rows from the bottom row to the row just below
the last row with data.  This has not helped.

This problem did not exist when I first moved the worksheet to my PC
with Excel2007.  It is recent.  I must have inadvertently changed an
option setting somewhere.  The problem does not exist with all
Excel2007 worksheets, only this one.  

I have only come up with one workaround - not a fix.  I can save the
workbook as a 'xls' file, move it back to my old PC, use Excel2000 to
insert the row, & move it back to the new PC with Excel2007.  Then
Excel2007 will recognize the new row although I still can't insert a
new row using Excel2007.

The problematic workbook only has 65636 rows, not the 1048576 expected
even when saved as a 'xlsx' file using Excel2007 probably due to the
fact Excel2000 created the workbook.

I would really appreciate it if someone could help me with this.