Datasheet view is disabled SharePoint 2010

Client machine attributes:

OS- windows 7

Explorer- IE9, 64-bit

SP version- SP2010

One of my users has reported an issue that he is facing some problems while using datasheet view. Further probing, we know the truth that he has created a custom list and then trying to click on ‘datasheet view’ but the option is disabled i.e. datasheet view is greyed out.

Error message:

This control is currently disabled.

Resolution:

Million thanks to Microsoft for publishing this KB and make it available to us to understand the background as well as resolution on this issue.

Link: http://support.microsoft.com/kb/2266203

As per this article:

You can install the 2007 Office System Driver: Data Connectivity Components to enable the Datasheet component. These components are available from the Microsoft download center:

2007 Office System Driver: Data Connectivity Components

Concrete Fix:

Go for a 32-bit office version, rather than 64 bit.

Open with Explorer is disabled - SharePoint 2010 and SharePoint 2013

Problem description:

-SharePoint 2010: Open with Explorer disabled on specific library.

-Open with Explorer greyed out.

-SharePoint Won't Allow Opening with Windows Explorer.

-SharePoint "Explorer View" doesn't work.

Error Message: Most probably you will get:

Your client does not support opening this list with Windows Explorer

Let me tell you guys that this section is very widespread and can be happen because of so many reasons. I don’t want to restrict this thread with only one solution as while debugging on this issue, I have explored so many options and would like to share all the options with you so that you can take a benefit of this and issue can be resolved in easy as well as proficient manner.

I am going to elaborate this information in step by step manner so in case of any queries/questions regarding any step then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.

Multiple Resolutions:

1)   Make sure the Office client should be installed on the machine.

2)   Make sure the web client service in started mode, How to check this: On your machine- Start-Run-services.msc-start the webclient service.

3)   Make sure the IE (Internet Explorer) Version should be 32-bit and not a 64-bit. How to check this: http://www.tracker-software.com/knowledgebase/280-How-do-I-tell-if-I-am-using-a-32-bit-or-64-bit-version-of-IE    

4)   Make sure the client integration is Enabled in Central Administration

How to check this: Central Administration-Manage web applications-Ribbon-Authentication Providers-Client Integration check box.

5)   Make sure the STSSYNC add-on should be enabled in IE. How to check this: Open IE-Tools-Manage Add-Ons-Look for the STSSYNC add-on and enable it.

6)   Make sure this option “Enable additional actions and Online Status for members” in Central Administration is set to Yes. How to check this: Open the Central Administration page-Click on Manage web applications-Select the web application you would like to configure-From the ribbon select General Settings-In the section titled Person Name Actions and Presence Settings change the setting Enable additional actions and Online Status for members to Yes-Click OK to apply changes.

7)   Make sure the ActiveX Control is enabled in Internet Explorer. How to check this- Open IE-Tools-Manage Add-Ons-Look for the STSUpld UploadCtl Class add-on and enable it.

8)   Make sure the Internet Explorer settings should not be too high. How to check this: http://windows.microsoft.com/en-in/windows-vista/change-internet-explorer-security-settings

9)   Make sure the protected mode should not be enabled in Internet Explorer. How to check this: Open internet explorer- Click on Tools menu and select Internet Options- Select Security Tab in the Internet options windows- Select Internet from the zone settings- Uncheck Enable Protected Mode option to disable the protection from Security for this zone- Hit Apply and Ok.

10)               Make sure the SharePoint site should be added inside trusted sites zone. How to do this: http://sharepointknowledgebase.blogspot.in/2010/07/site-prompts-for-credentials.html

Valuable suggestion from George Melnic:-

For Datasheet view, installing the AccessDatabaseEngine from Microsoft can actually solve the issue for both 32 and 64 bits IE versions (I am on IE 8 64 bits), this can be downloaded from here: http://www.microsoft.com/en-us/download/details.aspx?id=13255

 
Thank you once again!

I would like to request you if you have any different resolution apart from the above mentioned then please share here so that it would be beneficial for others as well.

Happy SharePoint to all of U...

If you have any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.