G
Guest
Hi all,
I'm having a problem with Excel 2000 when I am trying to insert a new row in
the middle of an existing worksheet.
I keep getting an error message that says:
"To prevent possible loss of data, Microsoft Excel cannot shift nonblack
cells off the worksheet.
Try to delete or clear the cells to the right and below your data. Then
select A1, and save your workbook to reset the last cell used.
Or, you can move the data to a new location and try again."
The worksheet goes down to row 18398, and I have tried deleting and clearing
every cell below and to the right of this row to make sure that there is no
data hidden away anywhere.
However it doesn't seem to make any difference, I still cannot enter a new
row. It did allow me to actually insert a row, but then the next time I tried
insert a row I got the same error message.
Any help will be appreciated
Thanks in advance
I'm having a problem with Excel 2000 when I am trying to insert a new row in
the middle of an existing worksheet.
I keep getting an error message that says:
"To prevent possible loss of data, Microsoft Excel cannot shift nonblack
cells off the worksheet.
Try to delete or clear the cells to the right and below your data. Then
select A1, and save your workbook to reset the last cell used.
Or, you can move the data to a new location and try again."
The worksheet goes down to row 18398, and I have tried deleting and clearing
every cell below and to the right of this row to make sure that there is no
data hidden away anywhere.
However it doesn't seem to make any difference, I still cannot enter a new
row. It did allow me to actually insert a row, but then the next time I tried
insert a row I got the same error message.
Any help will be appreciated
Thanks in advance