Select the product you need help with

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.

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.

Back to the top | Give Feedback

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.

Back to the top | Give Feedback

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 Yes for "Require content approval for submitted items"

Back to the top | Give Feedback

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

(http://go.microsoft.com/fwlink/?LinkId=151500)

for other considerations.

Back to the top | Give Feedback