Missing "Edit in DataSheet" option in SharePoint Lists
I was just looking in to a SharePoint website, which uses Forms Based Authentication scheme. I noticed that the SharePoint lists ware not having options such as Edit in Datasheet, Export to Spreadsheet, and Open with Access under Actions Menu. I realized that these are client based applications, so I thought there is an option on Sharepoint central administration to enable these options.
So I moved to below locations
Central Administration ->
Application Management ->
Authentication Providers (Under Application and Security)
In Authentication Provider’s, make sure you are in particular web application and then Select the Membership Provider's Zone, and check that you have enabled the Enable Client Integration Option.
Once the Enable Client Integration option is enabled you will see those options for integrating with client application options on Sharepoint lists.
Shantha Kumar T ( MCTS )
Posted @ Tuesday, May 17, 2011 8:46 PM by Sahil
I am using sharepoint 2010 and i am not getting Edit in Spreadsheet option under action.
I checked Enable Client Integration Option.Actually already this option was checked.So i unchecked and checked that option but still not getting Edit in Datasheet option.