Unable to edit a list in SharePoint Datasheet View with Content Approval turned on
Original KB number: 2274841
Symptoms
When choosing to edit a list in Microsoft SharePoint Datasheet View, the list or view is read-only. You can observe this by seeing the message "This view is read-only" at the bottom of the datasheet.
Cause
The Microsoft SharePoint Content Approval setting has been turned on for the list. The Datasheet View control doesn't support making edits to lists that have Content Approval turned on.
Resolution
Make your edits in Microsoft SharePoint Standard View or turn off Content Approval.
To turn off Content Approval in Microsoft SharePoint, do the following:
- In the list, select Settings.
- Select List Settings.
- Select Versioning Settings.
- In the Content Approval section, select No for Require content approval for submitted items.
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for