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

Article ID: 2274841 - View products that this article applies to.
Expand all | Collapse all

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 Yes for "Require content approval for submitted items"
Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.

Properties

Article ID: 2274841 - Last Review: July 8, 2010 - Revision: 1.0
APPLIES TO
  • Microsoft Office Access 2007
  • Microsoft Office SharePoint Server 2007
  • Microsoft SharePoint Server 2010
  • Microsoft Access 2010
Keywords: 
KB2274841

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com