07 September, 2010

Dataview does not work work in SP 2010

Hey Guys, 

This is another post based on Office 2010 issue in combination with SharePoint.

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.

What happens exactly:
I have Office 2010 installed but when I tried to open a list in Sharepoint Server 2010 in dataview I get the "datasheet component combatible with SharePoint Foundation is not installed" error.

Resolution:

after lots of research n troubleshooting, i found out this great article which is published from Microsoft:

If your business needs justify using the 64-bit version of Office 2010, you can install the 2007 Office System Driver: Data Connectivity Components to enable the Datasheet component. These components are available from the 


Microsoft download center:http://www.microsoft.com/downloads/details.aspx?familyid=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en

Office 2007: Microsoft Office Diagnostics

This is one of the vital feature which is enclosed by Microsoft in Office 2007.

Microsoft Office Diagnostics in the 2007 Microsoft Office system is a series of diagnostic tests that can help you discover why your computer is crashing (closing abnormally). The diagnostic tests can inform you about problems and might identify ways that you can solve other problems.
When Office Diagnostics determines that the data might help diagnose and fix a problem.

The Office Diagnostics are:

Setup Diagnostic:
This test checks for corruption in the files and registry settings in your 2007 Microsoft Office system installation. Files and settings can be corrupted by malicious viruses or by hardware that is faulty or incorrectly configured.

Disk Diagnostic:
This test looks for evidence of problems with your hard disk. Specifically this test checks for errors logged by the following:

-The Windows system event log.

-The Self-Monitoring, Analysis and Reporting Technology (SMART) feature of your hard disk. SMART is a feature that some disk drive manufacturers provide to give users advance notice of potential hard disk failure.

Memory Diagnostic:
This test verifies the integrity of your computer's random access memory (RAM).

Check for known solutions:
This test reviews the data on crashes of the 2007 Office release that have recently occurred on your system. The test then connects to a server to look for any solutions that might be available for the problems that caused these crashes.

How to run Office Diagnostics:

Click the Microsoft Office Button, and then click Excel Options.
Click Resources.
Click Diagnose, click Continue, and then click Start Diagnostics.


If you face any issues/queries regarding the above information then please let me know,Thanks.