Re: Can't Insert New Columns-Cannot shift objects off sheet error

[Lady Layla]

You cant just "clear" the area you need to actually delete the entire rows and
entire columns in question.


Go to the last true active cell of your data, select all columns to the right of
this, delete column. Save. Close file, reopen


:
: HELP! No fixes or Macros seem to work. Went thru all the cell
: clearing/comment clearing functions I could find in user group articles.
: Cleared the ENTIRE worksheet repeatedly. Ran the Macro recommended in MS
: Article 211769. What is wrong?
:
: This has been a problem with my worksheets and those of others in my office,
: especially if converted from lotus 123 originally, but affects new worksheets
: too. When trying to insert new columns in a worksheet, get the error message:
: "To prevent possible loss of data, Excel cannot shift nonblank shells off
: the worksheet. Try to locate the last nonblank cell by pressing CRTL + END
: and delete or clear all cells in between the last cell and the end of your
: data. Then select cell A1 and save your workbook to reset the last cell
: used. Or you can move the data to a new location and try again."
:
: Even when you do this several times, or there is no data in the other the
: parts of the worksheet, you still cannot insert new columns. I have to save
: > the worksheet in Excel in a lotus format, go into lotus, insert the columns,
: > save the now lotus worksheet in an Excel format and call it back into Excel
: > and resave it there. At some point, we will probably have to discontinue
: > lotus. How do I overcome this problem?
: > --
: > Ava Healy.
:
:
:
:
:
:
: --
: Ava Healy.

 

[Guest]

Thank you Lady Layla. That actually worked. I deleted every column until
the complete end of the worksheet, then every row to the very (bitter?) end,
saved the worksheet and it let me then add a column. Finally, yeaah!

Do you know what it is that causes this, or is it just a bug?

 

[Lady Layla]

I have found it happening if I accidently hit END and go all the way to the
right or bottom and either enter a # then clear it or if I am formatting cells
and inadvertantly format the entire row or entire column.

Excel should be more proactive on clearing cells, but if you just clear contents
you are not clearing formatting etc.

Glad it worked for you!


: Thank you Lady Layla. That actually worked. I deleted every column until
: the complete end of the worksheet, then every row to the very (bitter?) end,
: saved the worksheet and it let me then add a column. Finally, yeaah!
:
: Do you know what it is that causes this, or is it just a bug?
:
: "Lady Layla" wrote:
:
: > You cant just "clear" the area you need to actually delete the entire rows
and
: > entire columns in question.
: >
: >
: > Go to the last true active cell of your data, select all columns to the
right of
: > this, delete column. Save. Close file, reopen
: >
: >
: > : > :
: > : HELP! No fixes or Macros seem to work. Went thru all the cell
: > : clearing/comment clearing functions I could find in user group articles.
: > : Cleared the ENTIRE worksheet repeatedly. Ran the Macro recommended in MS
: > : Article 211769. What is wrong?
: > :
: > : This has been a problem with my worksheets and those of others in my
office,
: > : especially if converted from lotus 123 originally, but affects new
worksheets
: > : too. When trying to insert new columns in a worksheet, get the error
message:
: > : "To prevent possible loss of data, Excel cannot shift nonblank shells off
: > : the worksheet. Try to locate the last nonblank cell by pressing CRTL +
END
: > : and delete or clear all cells in between the last cell and the end of your
: > : data. Then select cell A1 and save your workbook to reset the last cell
: > : used. Or you can move the data to a new location and try again."
: > :
: > : Even when you do this several times, or there is no data in the other the
: > : parts of the worksheet, you still cannot insert new columns. I have to
save
: > : > the worksheet in Excel in a lotus format, go into lotus, insert the
columns,
: > : > save the now lotus worksheet in an Excel format and call it back into
Excel
: > : > and resave it there. At some point, we will probably have to
discontinue
: > : > lotus. How do I overcome this problem?
: > : > --
: > : > Ava Healy.
: > :
: > :
: > :
: > :
: > :
: > :
: > : --
: > : Ava Healy.
: >
: >
: >