Datasheet view is Grayed out - Sharepoint 2010

Today I found that there in our orgnaisation there were some upgrades done to the machine

Office 2010
IE 8
Windows 7 etc ;

Some of the users were facing issue with opening the Sharepoint list in the datasheet view .

researched and found it to be an issue with Office or IE

Ran the Repair on Office 2010 Proffessional plus however it didnt resolve the issue .

Checked the version of IE . user had opened the site in IE 64 bit and saved it as favourites .

asked the user to open IE (32 bit ) and check .

Oh the user was happy to see the Datasheet view back .

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

IE crashes when opening Datasheet view on sharepoint

There is no one Solution to this issue . I have found that it may happen due to various reasons .

"The list is displayed in Standard view. It cannot be displayed in Datasheet view for one or more of the following reasons: A datasheet component compatible with Windows SharePoint Services is not installed, your browser does not support ActiveX controls, or support for ActiveX controls is disabled"

Resolution :

* Try clearing the IE cache .it may workout to be the best and quick solution 

* Try Doing a Repair of Office . or reinstall

* Windows SharePoint Service Support options for Microsoft Office should be installed (applicable for Office 2003 as well as for Office 2007)

How to enable this option:

-Start-Control Panel-Add or Remove Programs-click on Microsoft Office and then Change
-Add/Remove Features
-Expand the Office Tools category.
-Next verify that you have both the Microsoft Office Access Web Datasheet Component and the Windows SharePoint Services Support component installed.
-If these components are not installed choose to run them from your computer and then click the Continue button and go through the installation process. You may need your Office 2007 install media.


* Check if ActiveX controls are active in Internet Explorer.
To do this open IE and go to the Tools menu > Internet options

* Select "Enable" for Script ActiveX controls marked safe for scripting.

* Adjust these settings accordingly and then click OK twice to return to Internet Explorer.

If you are running Internet Explorer 9 (32 and 64-bit are installed at the same time) use the 32-bit version. SharePoint doesn’t like using datasheet view if you are running IE9 on a machine with Office 64 installed so I will recommend installing Microsoft Office Access Database Engine 2007 (haven’t tried 2010) found here:

2007: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en

2010: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=c06b8369-60dd-4b64-a44b-84b371ede16d

Duplicate items appear when viewing items in Datasheet view

ISSUE:

Duplicate items appear when viewing items in Datasheet view in SharePoint. This also happens when using the Export to Spreadsheet (Excel). If duplicate entries appear in Datasheet view, they will also appear during Export to Spreadsheet and vice versa.

DESCRIPTION:

 The list has got versioning switched off, and views fine in standard list view. However, when you switch to either datasheet view or Export the file to Excel it shows the same rows three times in as sequence.

Resolution:

The affected lists have a Required lookup field which allows multiple values. If you have a view that does not include this field and it is either a datasheet or you "Switch to Datasheet" then datasheet shows duplicate items depending on how many multi-values are selected.

Our work-around was to create a specific Datasheet view with the field included. The multi-value field does not show in datasheet, because multi-value lookup fields don't seem to work in datasheet. However, it's important to include the field in the view to avoid duplicates. Unfortunately, if you have a view that does not include the field and then "Switch to Datasheet" you will encounter the same problem.

The duplicates appear also when you try to Export to Excel. If you have a view that would be affected by the "Switch to Datasheet" duplicate problem, when you try to Export to Excel, it will also appear.

Note : Please check with the Admin of the list before you uncheck multiple values.