Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Problem w/ lists: Datasheet View suddenly becomes "read only"

  Asked By: Edmond    Date: Aug 19    Category: Sharepoint    Views: 4308

This happened once before with a custom list I built, and it just
happened again in a document library.

I am able to use "edit in datasheet" to do mass updates, but suddenly
I lose this option- it becomes "read only".

I had no idea what happened the first time (w/ my custom list), but
just now I changed my "choice column" choices in my document library
and went into datasheet view to edit them and use the new choices. I
was able to, but after refreshing the data the view switched to "read

Anyone had this happen? Any idea how to make it editable again?
Datasheet view is awesome for multiple updates, so this could be a
real problem for me if there's no fix.

FYI: The affected custom list was created in my personal site, and the
affected document library was created in a team site. It may also be a
problem in portal, but I haven't tested it.



1 Answer Found

Answer #1    Answered By: Alexis Ellis     Answered On: Aug 19

I'm going to answer my own question here in case anyone else ever
struggles w/ this. I have found that if you change your general
settings to require content approval, datasheet  view no longer works
for you or anyone else. I'm not sure if/when there are exceptions- I
have yet to find any.

So...in case anyone else ever starts tearing their hair out over
this, check to see if you or someone else recently changed  the list
settings to require content approval.