SharePoint and Microsoft Office applications are designed to work together, but what if something goes wrong?  I recently ran into an instance where the datasheet view for a list would no longer work. As a matter for fact it, was not even presented as a option in the actions menu, but rather a new item label Open In Client appeared in its place.  Furthermore, I was also getting an error message of: "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 browser does not support ActiveX controls, or support for ActiveX controls is disabled."

Q: What does this have to do with Office Client integration, datasheet view is displayed in the browser, right?
A: Datasheet is displayed in the browser, but requires an ActiveX control that is installed with Microsoft Office.

After doing some searching, I quickly ran into Microsoft KB 909506 that gives the following as possible reasons for this not working:

  • A datasheet component that is compatible with Windows SharePoint Services is not installed.
  • A Microsoft Office 2003 Professional edition is not installed on the computer.
  • The Web browser does not support ActiveX controls.
  • Support for ActiveX controls is disabled.
  •  

    Nowhere does the KB article mention anything about Office 2007, so what gives?  The solution that I found was to use the Office Repair tool

    1. Open Microsoft Word 2007.
    2. Click the Office Button in the top-left of the window and select Word Options.
    3. In the resulting dialog, select the Resources link in the left menu.
    4. Click the Diagnose button to run Microsoft Office Diagnostics.

     

    After the diagnostic tool completes, hopefully, your client integration features have been repaired.