Featured

Fix for Datasheet View Issue / Error in SharePoint 2010

Issue: 
I have Office 2010 installed but when I try to open a list in Sharepoint Server 2010 in dataview I get the "datasheet component compatible with Sharepoint Foundation is not installed" error.



Resolution: 
Try installing the 2007 Office System Driver: Data Connectivity Components after you have installed Office 2010 64-bit on the client machine. This should provide you with the edit in Datasheet functionality. Let us know how it works out.


Explanation:
If you are experiencing an error in SharePoint 2010 as follows:
"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 320bit or 64-bit support."
I've compiled the following steps you can take from forums and articles around the web:
If you are running Office 2010, 64-bit (with IE7 or IE8):

1. Ensure that your browser settings have the site in Trusted Sites in the Internet zone, and that ActiveX controls are enabled.
2. Install the 2007 Office System Driver: Data Connectivity Components.  I can confirm that this solution has worked for several of my colleagues. 
Solution     
Source: click  
MS Knowledgebase article:  click

If you are running Office 2007:

1. Ensure that your browser settings have the site in Trusted Sites in the Internet zone, and that ActiveX controls are enabled.
2. Ensure that the Microsoft Office Access Web Datasheet Component and the Windows SharePoint Service Support options for Microsoft Office are installed. (Steps here)


Comments

Tj Zach said…
That's correct Sir G... :)

Popular Posts