In this article we can work with the Datasheet View of Lists in SharePoint 2010.
Do you know about the Datasheet View of Lists?
This was a new feature in SharePoint 2010 and continued in SharePoint 2013 as well. This feature allows build data entering in a more convenient way. Following is the screen shot of a List in the Datasheet view:
How to enable Datasheet View?
Let us see how to enable Datasheet view. First, create a list named Job and add some text and number columns into it.
Click on the Create View link from the bottom of the page. You will get the following page.
Choose the Datasheet View as shown above.
In the appearing page, enter a name for the view and choose the columns to be displayed. You may choose to set this view as Default.
Click the OK button to save changes and your Job lists should look like below:
You may try adding data, copying / pasting, bulk delete, etc.
Additionally, we can fill one cell value to all others by clicking and dragging the cell boundary.
While working with datasheet view, you might encounter the error: The selected cells are read-only.
There could be different cases arising to the above error. I would like to list the solutions one by one.
Case 1: Content Approval
If the list requires content approval, you might need to disable it working with datasheet view.
Solution: List > List Settings > Versioning Settings > Set Require Content Approval to False
Case 2: MS Access Components are not properly installed
The datasheet view is working through MS Access ActiveX control.
Solution: You can verify the MS Office installation in the client side.
Case 3: Read Only Columns in the View
The view might contain other read-only columns creating problem while copying & pasting.
Solution: You can hide those columns in the Datasheet view and try copy / paste with the required cells selected
From the above feature I believe we can agree the High Productivity Offers of SharePoint at the Least cost. The same functionality if provided by an ASP.NET / Web developers could take several hours of work. Thanks to SharePoint, we can provide quick Datasheet view for all our lists.
In this article we have seen how to use the Datasheet view of SharePoint. The points worth summarizing are:
· Datasheet view provides a quicker solution to bulk data entry, copy / paste requirements
· Datasheet view is a SharePoint 2010 feature
· Datasheet view requires Internet Explorer, ActiveX for MS Access installed