Dataview does not work work in SP 2010
-
Thursday, December 24, 2009 12:17 AMI have Office 2010 installed but when I try to open a list in Sharepoint Server 2010 in dataview I get the "datasheet component combatible with Sharepoint Foundation is not installed" error.
Answers
-
Thursday, July 01, 2010 6:45 PM
A KB article is now available that discusses using the 2007 Office System Driver: Data Connectivity Components as a workaround to provide the edit in Datasheet functionality. Please see http://support.microsoft.com/kb/2266203 for more information.
Thanks,
Jennie- Marked As Answer by Serge Luca [MVP]MVP, Moderator Thursday, July 01, 2010 6:56 PM
All Replies
-
Tuesday, January 26, 2010 8:54 AMModerator
This should work in IE7+. Make sure the datasheet is enabled in advanced List settings.
-
Tuesday, January 26, 2010 9:04 PMModeratoris activeX enabled in your browser ?
Serge Luca; blog: http://sergeluca.spaces.live.com Devoteam Belgium -
Tuesday, February 02, 2010 3:43 PM
Have you installed the 64 bit version of Office 2010? If so then Datasheet View will not work...see http://download.microsoft.com/download/8/0/2/8023B21C-B6FE-4EC2-9B93-8CCA52458A87/64bitClientInstallation_Office2010.pdf
Or, are you running 64 bit IE? If so then I suspect that may also present the same issue. -
Thursday, February 04, 2010 8:33 PMKevin is Microsoft going to provide this functionality soon for the 64-bit Office 2010 clients?
ME -
Monday, May 10, 2010 6:21 PM
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.
Thanks,
Jennie- Proposed As Answer by Jennie E [MSFT] Monday, May 10, 2010 6:21 PM
-
Friday, June 18, 2010 11:40 PMI can confirm that install the 2007 Office System Driver: Data Connectivity Components after install Office 2010 64-bit fixes the Datasheet View.
-
Monday, June 21, 2010 7:03 PM
Error Message: The list cannot be displayed in Datasheet View for one or more of the following reasons:
- A datasheet component compatible with Windows SharePoint Services is not installed.
- Your web browser does not support ActiveX controls.
- Support for ActiveX controls is disabled.
Machine Build:
- Windows 7 x64
- Office 2010 x64
- Internet Explorer 8 x64
…by default this configuration will NOT work. You need to do the following:
-
Install 2007 Office System Driver: Data Connectivity Components (from the above thread)
-
Use Internet Explorer 8 x86 usually found in C:\Program Files(x86)\Internet Explorer\iexplore.exe
-
Thursday, July 01, 2010 6:45 PM
A KB article is now available that discusses using the 2007 Office System Driver: Data Connectivity Components as a workaround to provide the edit in Datasheet functionality. Please see http://support.microsoft.com/kb/2266203 for more information.
Thanks,
Jennie- Marked As Answer by Serge Luca [MVP]MVP, Moderator Thursday, July 01, 2010 6:56 PM
-
Sunday, May 06, 2012 6:14 AM
- Windows 7 x64
- Office 2010 x64
- Internet Explorer 8 x64 ( C:\Program Files (x86)\Internet Explorer)
When i install this tool, I got different error:
"Internet Explorer has stopped working"
any other solution?

