SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.
Sign up to join this community
I have created a list using "Custom List in Data Sheet View". After that I created around 10 columns in that list. Problem is only for one column, it is showing as read only, rest all are working fine!! Hence I cannot insert a row in the list(Data sheet view).
How can I remove that read only attribute from the column?
One more related question is, how to make the list editable to only one group and read only to other groups?
Thank you, for your valuable inputs!!
You should go to list tab on the ribbon, then open list permissions settings. In this settings you can add two groups (or use existed groups) and set Read rights for one group and Contribute rights for another. By default the list inherits permission from a site. You can broke this relationship by Stop inheriting permission button.
what type of this field?
I had a very similar issue. I'd added a Rich Text column for notes to an existing list. I could add text to the Notes field if I opened each list item and edited individually but edits to that field when in Datasheet View were met with "the selected cells are Read-Only".
I simply altered the rich text format to be plain text and it cleared up the issue.
I had a similar issue. I added a new column to a SharePoint list. The column type is "Multiple lines of text." The text type was "Enhanced rich text." I was unable to paste data into the column in datasheet view. I received an error message indicating that it is read-only. To solve my problem, I changed the text type to "Rich text."
Go into File. Click on Publish. When you get to the option to select the columns, click on the desired column and then click modify. Select the option to allow users to edit data. Repeat for all desired columns and complete publishing process.
