Home > MOSS2007 > This view is read-only in SharePoint 2007 datasheet view

This view is read-only in SharePoint 2007 datasheet view

Hi Friends,

While working with Microsoft Office SharePoint server 2007 datasheet view will help end users to add or edit the SharePoint list data using Excel like view.

But some time if you found a message at the bottom of the datasheet view as ‘This view is read-only.’ (As shown in below image) and you are not able to add, delete or update the record using the datasheet view.

To resolve this you need to go to the ‘List setting’ section of that same list and select ‘Versioning Settings’ from General Settings section.(As shown in below image)

Now go to ‘Content Approval’ section and set ‘Require content approval for submitted items?’ to No.(As shown in below image)

Happy coding….

Advertisements
  1. March 7, 2012 at 2:44 pm

    This could be a single particular of the most valuable sites We have ever arrive across on this subject. Genuinely Spectacular. I am also a expert in this topic so I can fully understand your very difficult labor.

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: