Missing “Edit in DataSheet” option in SharePoint Lists

I was just looking into 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 )
[email protected]