SharePoint List Cannot Be Displayed in Datasheet View

When clicking on ‘Datasheet View’ button in List tab’s ribbon on a SharePoint 2010 site, or clicking on ‘Actions’ then ‘Edit in Datasheet’ on a ShrePoint 2003 or 2007 site, to view and manage the list items in spreadsheet format, the following error may occur:

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.

Continue reading »