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

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).   Solution: You just need to install the 32 bit Data Connectivity Components.  https://www.microsoft.com/en-us/download/details.aspx?id=23734