Wednesday, 18 November 2015

DataSheetView in SharePoint 2010

               Recently I have faced one problem, In my project we are changed the status from x to y, In coding side we did all changes but for existing records we need to update the status for all the records. In that scenario we approach this method. In this article I'm trying to explain how to update multiple records in SharePoint 2010. In some cases we need to mass update bulk of records in that case using DatasheetView we can achieve this.
 

Update SharePoint List using DataSheetView in SharePoint2010:


Recently I have faced one problem, In my project we are changed the status from x to y, In coding side we did all changes but for existing records we need to update the status for all the records. In that scenario we approach this method. In this article I'm trying to explain how to update multiple records in SharePoint 2010. In some cases we need to mass update bulk of records in that case using DatasheetView we can achieve this.

Hardware Requirements:

To achieve this office 2007 with 32bit format is required, usually everybody is using 64bit format. If you don't have 32bit format in your machine, DataSheetView option is not enabled.

To download refer below link

http://www.microsoft.com/en-us/download/details.aspx?id=23734

After Install the above software in your machine follow the below steps.

Step 1:

Please open your SharePoint site in IE Browser alone, because DataSheetView supported browser is IE.

Step 2:

Go through Site Actions and click on View All Site Content then choose your List, and next to Site Actions option there are few options like Browse, Items, List. Click on List.

Step 3:

Initially DataSheetView is in Disabled state.
 

Step 4:


After Install AccessDataBaseEngine 32bit version, DatasheetView option in enabled.
 

Step 5:

Click on DatasheetView in the Toolbox, it will open the data in excel sheet format.
 

Step 6:


Now, which column you want to update select that column, in my scenario I want to update Status column.

Select the rows of particular column and edit the 1st row



Step 7:


What are all the row's you need to update select all those and then Right click Fill--> FillDown this will help you to update the records and then click on standard view.

Conclusion:


Hope this article will help you those who are looking for the same.