SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

The selected cells are read-only when trying to delete items in DataSheet mode. Anyone cmae across this as i need to delete my blog list items in bulk i don't want to delete them individually its going to take toooo long. Thanks

share|improve this question
sorry guys fixed.The approval blog process tied it up to read only :( – naijacoder Aug 12 '11 at 6:21

It will come up saying "The selected cells are read only" if you have a multiple lines of text field that is anything other than "Plain Text" (Such as the body section of a blog post), as Datasheet view has no idea how to deal with HTML etc.

If you want to delete posts in bulk, i would recommend just creating a view that does not contain this field, then selecting the entire row in datasheet view (by clicking the grey tab to the left of the row), right-clicking, and selecting "Delete Rows"

share|improve this answer
up vote 0 down vote accepted

Thanks Mike for the reply.I did try all that but no luck.But i later found out the Approval process built into the blog template was affecting it.As soon as i desable the content approval i could delete it :)

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.