Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Read-Only Datasheet View

  Asked By: Bob    Date: Jul 27    Category: Sharepoint    Views: 35512

I have a quick question for you all. Does anyone know why when I have a list open in Datasheet view it is read only? There are a number of changes that need to be made to some of the records in the list and it would be way easier to just edit and make the changes in the datasheet view. It is really odd, because if you open a list and then choose the approve/reject view and then view the approve/reject in datasheet view it works fine and is not read only. Has anyone experienced this? Is there a setting that needs to be changed?



6 Answers Found

Answer #1    Answered By: Donta Kirkland     Answered On: Jul 27

Are you a local administrator on the sharepoint box? If not what is your permissions level? Sometimes this behavior can be caused by permissions level. There are a number  of other reasons why you could be experiencing this kind of behavior as well. Something such as a free form text fields, attachments, or calculated fields sometimes cause this. I am sure someone might be able to pinpoint your problem better than I can. Maybe a screen shot or a list  of the different data types that show up in the all items view  that you are trying to edit. Another thing you could try is export to excel spread sheet update a few items and then use the sync command button the list toolbar to sync the data back to sharepoint with your local changes. If this works  for you fixes your error you could do them all that way. This way you don't time out on the webpart page making changes and lose a bunch of data.

Answer #2    Answered By: Cade Velazquez     Answered On: Jul 27

Another question  in addition to your permission level: When you open  in
datasheet view, do you get any messages that tell you that some
required fields are not shown in that view? That will also put the view
into read  only mode.
The best view  to use as a datasheet  view is AllItems.aspx as long as
all custom columns have been added to the view.

Answer #3    Answered By: Ariana Christensen     Answered On: Jul 27

I’ve been having the same problem. I DON’T think that I have all required fields in the view, but I don’t get any messages. I will try that !

Answer #4    Answered By: Darrius Whitfield     Answered On: Jul 27

Is "Content Approval Required" set to "Yes" for this list?
Unfortunately, the only way I found to get around this was to set it
to "No" while I made  the necessary changes in the Datasheet View.

Hope this helps. Let me know if you found a different way to solve
this issue.

Answer #5    Answered By: Trevor Davis     Answered On: Mar 19

I have a similar problem. I created a "form library" through InfoPath. After data is loaded via InfoPath to the table, I export the datasheet  table to Excel, but the table comes out as read  onlo. Not only is it read only in Excel, BUT also in the Datasheet view  (all items). While I don't want to change data or do mass uploads I would like the fucntionality of editing a few fields through Excel to be available

Answer #6    Answered By: Mike Frenette     Answered On: Aug 22

You may have multiple lines of text fields set to Enhanced Rich Text. This will not work in datasheet mode.

Change them to either Plain Text or Rich Text.

Didn't find what you were looking for? Find more on Read-Only Datasheet View Or get search suggestion and latest updates.