Unable to Edit List in Datasheet View in Microsoft SharePoint with Content Approval turned on

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 does not 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:
 
  1. In the List select Settings
  2. Select List Settings
  3. Select Versioning Settings
  4. In the Content Approval section select No for "Require content approval for submitted items"
Properties

Article ID: 2274841 - Last Review: Oct 1, 2015 - Revision: 1

Feedback