You are the Office 365 administrator for your company. Employees do not have local
administrative privileges on client computers.
The company has the following client computer software:
• Windows 7 and Windows 8
• 32-bit and 64-bit Office 2007, Office 201 0, and Office 2013
When accessing the corporate Microsoft SharePoint 2010 site, some users are unable to
display SharePoint lists in the Datasheet view.
You need to ensure that all users can display SharePoint lists in the Datasheet view.
What should you do?
A.
Upgrade to the latest version of Office 365 ProPlus.
B.
Force a reinstallation of Office by using Group Policy and specifying a network location.
C.
Uninstall the 64-bit version of Office and then install the 32-bit version of Office.
D.
Upgrade all Office 2007 and Office 2010 versions to Office 2013.
For SharePoint Server 2010, 64-bit versions install some Office 32-bit client-side controls for supporting solutions in a 32-bit browser (the default browser on current 64-bit Windows systems). The Edit in Datasheet view functionality in SharePoint Server 2010 isn’t supported if you install 64-bit Office 2013 client. The Edit in Datasheet functionality is available if you install 32-bit Office 2013 client
https://technet.microsoft.com/en-us/library/ee681792.aspx#compat4
Luis had done the needful and speaks truth!
Answer is C – you need the 32bit of Office installed as The Edit in Datasheet view functionality in SharePoint Server 2010 isn’t supported if you install 64-bit Office 2013 client.