Error message:

The list cannot be displayed in Datasheet view for one or more of the following reasons:

– A datasheet component compatible with Microsoft SharePoint Foundation is not installed.

– Your Web browser does not support ActiveX controls.

– A component is not properly configured for 32-bit or 64-bit support.


Symptom: When trying to click datasheet view in SharePoint 2010 with Windows 10, IE 11, and  Office 2016 (Excel 2016 x64).



You just need to install the 32 bit Data Connectivity Components.