I am very new in SharePoint. I got a task to display my table data in SharePoint list and provide the Action menu. Inside the action menu there should be a option for "View in DataSheet".

Can any one tell me how can I get "Action->View in DataSheet" option on the left side of list.

If possible then please tell me how can i achieve this.



  • It is very frustrating that MS still has not released a 64bit ActiveX component for viewing Datasheets in Sharepoint.. Seriously MS, it'll take your guys less than a week to write the component... It affects A LOT of users!
    – Fox
    Jul 7, 2011 at 8:46
  • Possible duplicate: sharepoint.stackexchange.com/questions/13262/…
    – Stu Pegg
    Jul 7, 2011 at 9:09
  • Thankx Is there any way to populate the datasheet with datasource
    – user4027
    Jul 7, 2011 at 10:38

1 Answer 1


First, you can see "Datasheet" view in IE only by default. Go to list settings or View combo box and click on "Create View". Select 'Datasheet View', choose it's name and check columns that you want to see. If you want it by default when someone open the list, check "Make this the default view" option and save the view.

Second, there is an issue with Datasheet view together with 64-bit 2010 Office and you need to rewrite one Data connectivity driver, see this link



Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.