Help!

Excel 2007 won't allow me to insert a row

 
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> New Users RSS
Next:  Learning how to use it & the Vista, on laptop  
Author Message
David
External


Since: Jul 05, 2007
Posts: 11



PostPosted: Sat Aug 04, 2007 1:13 pm    Post subject: Excel 2007 won't allow me to insert a row
Archived from groups: microsoft>public>excel>newusers (more info?)

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.
Back to top
Roger Govier
External


Since: Jul 31, 2007
Posts: 34



PostPosted: Sun Aug 05, 2007 3:12 pm    Post subject: Re: Excel 2007 won't allow me to insert a row [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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
>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.
Back to top
David
External


Since: Jul 05, 2007
Posts: 11



PostPosted: Tue Aug 07, 2007 1:10 am    Post subject: Re: Excel 2007 won't allow me to insert a row [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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.aspx?scid=kb;en-ca;211769
Back to top
Rachel
External


Since: Aug 07, 2007
Posts: 1



PostPosted: Tue Aug 07, 2007 11:59 am    Post subject: Cannot Shift Objects Off Sheet - Excel - Possible [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Hi, I have been having this problem with Excel too. I have tried all of tips of here: 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
Back to top
shawnlander



Joined: Aug 29, 2007
Posts: 1



PostPosted: Wed Aug 29, 2007 2:50 pm    Post subject: [Login to view extended thread Info.]

We had a similiar issue here on a spreadsheet that has been used for years and years and converted from one version to the next.

It turns out there was a hidden picture on the sheet that was preventing the insertion of new rows/columns. The picture wasn't showing up in an print previews or views of the header/footer and was long since forgotten that it was there.

Running 'Office button->Prepare->Inspect Document' did not show the picture either. It did find some comments however that were also an issue.

To find that picture I had to enable viewing all objects from 'Office button->Excel Options->Advanced->For Objects Show ALL' in the 'Display options for this workbook' section (you have to scroll down about half-way).
Back to top
racecat



Joined: Aug 30, 2007
Posts: 1



PostPosted: Thu Aug 30, 2007 2:27 pm    Post subject: [Login to view extended thread Info.]

Hi Shawnlander

Found that I only needed to make all objects visible to allow me to insert columns - unlike your picture there was nothing that had to be deleted.

Really odd but it worked, thank you.

atb
rc


> To find that picture I had to enable viewing all objects from 'Office button->Excel Options->Advanced->For Objects Show ALL' in the 'Display options for this workbook' section (you have to scroll down about half-way).
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> New Users All times are: Eastern Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum