insert row

[dtwlee]

Version: 2008 Operating System: Mac OS X 10.4 (Tiger) Processor: Power PC when I click on insert row, it comes back with "cannot shift objects off sheet". I did not have this problem with Office 2004. What to do?

 

[Bob Greenblatt]

Version: 2008 Operating System: Mac OS X 10.4 (Tiger) Processor: Power PC when
I click on insert row, it comes back with "cannot shift objects off sheet". I
did not have this problem with Office 2004. What to do?

This is not an excel 2004/2008 problem, but a problem with your worksheet.
What is happening is that you have some content (maybe even a single space
character) near the bottom of the sheet. The insert is trying to move this
off the bottom. You will need to find the data and delete it. Using
ctrl-end, Or edit-goto-special-last cell may help you find the problem.

 

[CyberTaz]

Further to Bob G's reply, one of the most common causes of this type of
problem is indiscriminate copy/paste from other types of files ‹ especially
copying from web sites. Get in the habit of using the options in Edit> Paste
Special if you must snatch data from elsewhere.

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[dtwlee]

I tried the suggestion regarding my problem with the insert row function, but without success. There is nothing in the cell pointed to by using ctrl-end or edit-goto-special-last cell (it is nowhere near the bottom of the sheet). I even tried to clear and delete whatever is in that cell but to no avail. The file I am working on was created with Office Excel 2004. A macro has been used to copy some of the columns in the file. Could there be an incompatibility problem now that I am using Office 2008? I find that when I go back to using Office 2004, the problem goes away and I have no trouble inserting a new row in the file. Am I stuck in always having to go back to Excel 2004 when working with this file?

 

[Bob Greenblatt]

I tried the suggestion regarding my problem with the insert row function, but
without success. There is nothing in the cell pointed to by using ctrl-end or
edit-goto-special-last cell (it is nowhere near the bottom of the sheet). I
even tried to clear and delete whatever is in that cell but to no avail. The
file I am working on was created with Office Excel 2004. A macro has been used
to copy some of the columns in the file. Could there be an incompatibility
problem now that I am using Office 2008? I find that when I go back to using
Office 2004, the problem goes away and I have no trouble inserting a new row
in the file. Am I stuck in always having to go back to Excel 2004 when working
with this file?

No, you should not be stuck with Excel 2004. It SHOULD work just fine in
Excel 2008. If the file does not contain any proprietary information, I
would be happy to take a look. You can send it to me at the email address
below. Just send a not with it explaining the problem, and where you are
trying to insert the row.

 

[CyberTaz]

I doubt that the macro has anything to do with it since 2008 has no VBA
support whatsoever. Despite your efforts so far there is 'something' at the
bottom of the sheet that is preventing the insertion of rows. Not only does
that 'something' not have to be visible, it doesn't even have to be *in* a
cell -- it can be some sort of object *on* the sheet. If it is something on
the sheet neither of the techniques you've tried will take you to where it
is... They only get you to used/occupied cells. Additionally, when the file
is open in 2008 it has 1M+ rows available whereas when open in 2004 there
are only 65K+ rows -- Although you'd get a compatibility notification if you
attempt to save the file with content below the last row available in the
..xls format. Is the file in .xls or .xslx format?

Try this:

With the file open in 2008 select the row below the last row of content you
want to retain,

Use the keystroke: Shift+Command+Down Arrow,

Go to Edit> Delete,

Then try again to insert a row.

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[dtwlee]

Thanks for all the suggestions. However none of them work. I have determined that the problem has to do with the difference between 2004 Excel and 2008 Excel. My original file was actually a workbook created with Excel 2004, consisting of 5 sheets with Excel 4.0 XLM macros in one of them. When I copied each of the sheet into an individual workbook, the insert row function works fine for each sheet, But together on one workbook, it refuses to work on any of the 5 sheets. I tried saving the file with the macros removed (xsli format), the insert row function again gives the same "cannot shift objects off sheet" comment. Anyway, thanks for all the help. Since I do need to use the macros for my application, sticking with Excel 2004 for this file is probably unavoidable.

dtwlee

 

[Bob Greenblatt]

Thanks for all the suggestions. However none of them work. I have determined
that the problem has to do with the difference between 2004 Excel and 2008
Excel. My original file was actually a workbook created with Excel 2004,
consisting of 5 sheets with Excel 4.0 XLM macros in one of them. When I copied
each of the sheet into an individual workbook, the insert row function works
fine for each sheet, But together on one workbook, it refuses to work on any
of the 5 sheets. I tried saving the file with the macros removed (xsli
format), the insert row function again gives the same "cannot shift objects
off sheet" comment. Anyway, thanks for all the help. Since I do need to use
the macros for my application, sticking with Excel 2004 for this file is
probably unavoidable.

dtwlee

Swell, I do not know what the problem is but I can assure you that it is
most definitely NOT due to the difference between Excel 2004 and 2008. XLM
macros work fine in Excel 2008. My offer to look at your workbook still
stands.

 

[filippo9]

> On 12/9/09 4:41 PM, in article (e-mail address removed)2ac0, "dtwlee@officeformac.com" wrote:
>
> Version: 2008 Operating System: Mac OS X 10.4 (Tiger) Processor: Power PC when I click on insert row, it comes back with "cannot shift objects off sheet". I did not have this problem with Office 2004. What to do?
> This is not an excel 2004/2008 problem, but a problem with your worksheet. What is happening is that you have some content (maybe even a single space character) near the bottom of the sheet. The insert is trying to move this off the bottom. You will need to find the data and delete it. Using ctrl-end, Or edit-goto-special-last cell may help you find the problem.
>
> --
> Bob Greenblatt [MVP], Macintosh
> bobgreenblattATmsnDOTcom
>

Thanks bob...I had the same problem and you solved it for me

filippo9

 

[filippo9]

Thanks, Bob. I had the problem too and you answer dolved it for me
filippo9