.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Articles >> SharePoint >> Post New Resource Bookmark and Share   

 Subscribe to Articles

Bulk Data entry with Datasheet View in SharePoint and Power User

Posted By:Jean Paul       Posted Date: October 28, 2013    Points: 200    Category: SharePoint    URL: http://www.dotnetspark.com  

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 and more
 


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.

 

Possible Errors

While working with datasheet view, you might encounter the error: The selected cells are read-only.

 

Solutions

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.

References

http://tinyurl.com/sp2010-views

Summary

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 


 Subscribe to Articles

     

Further Readings:

Responses

No response found. Be the first to respond this post

Post Comment

You must Sign In To post reply
Find More Articles on C#, ASP.Net, Vb.Net, SQL Server and more Here

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend