Unable to add/delete/clear content of a row

  • Thread starter Thread starter PeaceHere
  • Start date Start date
P

PeaceHere

My 2007 excel workbook has several sheets. One of them doesn't allow
me to add, delete, or clear content of rows. This means when I right-
click on a row, the "insert", "delete", "clear content" is grey
out. Same thing when I use the ribbon.

This only happens to this sheet, as the other ones don't have such
problem. I can modify the content of cells and the sheet is not
protected.

Can someone shed a light on this mystery?
 
I have Excel 2003, but could the Protect Sheet option be turned on for the
sheet (Tools | Protection | Protect Sheet menu in Excel 2003)
 
Sorry, didn't read your entire message. If the protection is not on, can you
copy all the data to a new sheet and delete the offending one?
 
I get the same issue. When I try to insert a row, it gives me a message
about there is a lot of data and that it will take several minutes. I accept
the message and it tries and then comes back with no change. I have tried
saving it as a old version of Excel, copy it from the network to my local
drive. There are three sheets in this workbook and two of the three are
fine. The third one will not work. This is a file that was originally
create in Excel 2003. I saved it as an Excel 2007 files yesterday and that
is when the problem started happening.
 
Back
Top