PROTECTED WORKSHEET....

[sylvain]

Hi

I am trying to make some modifications on a spreadsheet, and i cant do anything with it
If i try to delete a row, i receive the following message from EXCEL

************************************************************
To prevent possible lost of data EXCEL cannot shift nonblank cells of the worksheet.

Try to delete or clear the cells to the right and below 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

************************************************************
I can do change on any worksheet in the workbook except on that one,.

The worksheet is not protected nor share

Please help......

 

[Telsa]

Check the last column of your worksheet. See if you have any data. If nothing visible the delete from there inward as much as possible. Do a column delete. I use to have the same problem and usually it was a space or something not viewable in the worksheet. SOmetimes it might be best to highlight all of your data and paste it in a new worksheet.