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...b;en-ca;211769
--
Regards
Roger Govier



<David wrote in message ...
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.

Roger:
Thanks for the help!

Dave


On Sun, 5 Aug 2007 11:12:55 +0100, "Roger Govier"
<rogerattechnology4NOSPAMu.co.uk wrote:

Hi

Take a look at this article and see if it resolves your problem.
http://support.microsoft.com/default...b;en-ca;211769

Hi, I have been having this problem with Excel too. I have tried all of tips of he http://support.microsoft.com/kb/211769 but have had no luck. I didn't have any comments in my spreadsheet but I added one and then deleted it straight away and then I was able to add rows again and all of my insert options were back and usable. I can't explain it at all but try to add and delete a comment to see if that works as it has worked for me and a colleague.

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com