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:
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
- Open Microsoft Word 2007.
- Click the Office Button in the top-left of the window and select Word Options.
- In the resulting dialog, select the Resources link in the left menu.
- Click the Diagnose button to run Microsoft Office Diagnostics.
After the diagnostic tool completes, hopefully, your client integration features have been repaired.