Fix for SharePoint Datasheet Error: The list cannot be displayed in Datasheet view for one or more of the following reasons
When I try to open a SharePoint 2010 list in Datasheet View, It scolded me by throwing below error:
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.
Or you may face the similar issue:
“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 Microsoft SharePoint Foundation is not installed, your browser does not support ActiveX controls, a component is not properly configured for 32-bit or 64-bit support, or support for ActiveX controls is disabled.”
Troubleshooting:
First, you need to have an Office installation in order to use the datasheet view.
Yes, You may have Ms-Office installed. but the Edit in Datasheet view functionality is not supported if you install 64-bit Office 2010. However, the functionality is available if you install 32-bit Office 2010. The ActiveX control needed for the datasheet view is incompatible with the 64-bit version of Office.
Fix: Install Office 2007/2010 Access Run time – Data Connectivity Component:
Thanks you Salaudeen!!! I was very glad to not have to reinstall 32-bit Office on my PCs (and all my colleagues). Microsoft should be paying you for all your support. Considering it’s both their products that conflict, you’d think they’d manage this better, or provide reasonable error messages.
thanks a lots!
it worked like charm.
This solution worked for me as well.
Thanks a lot!
Worked perfectly; this was very helpful.
Thank you!