SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.



share|improve this question
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 '11 at 8:46
Possible duplicate:… – Stuart Pegg Jul 7 '11 at 9:09
Thankx Is there any way to populate the datasheet with datasource – user4027 Jul 7 '11 at 10:38

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

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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