Excel 2007 won't allow me to insert a row

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.

Hi

Take a look at this article and see if it resolves your problem.
http://support.microsoft.com/default.aspx?scid=kb;en-ca;211769
--
Regards
Roger Govier



<David> wrote in message news:hdt8b3143b9h8p2im34raero6f92blaq04@4ax.com...
>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.