G
Guest
This has been a problem with my worksheets and those of others in my office,
especially if converted from lotus 123 originally. 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?
especially if converted from lotus 123 originally. 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?