When attempting to create/open a document in a SharePoint list or view a list in Datasheet view, you receive one of the messages below:
1. 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. -OR- The list is displayed in Standard view. It 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 browser does not support ActiveX controls, a component is not properly configured for 32-bit or 64-bit support, or support for ActiveX controls is disabled. 2. The document could not be created. The required application may not be installed properly, or the template for this document library cannot be opened. 3. The document could not be opened for editing. A Windows SharePoint Services compatible application could not be found to edit the document.
There are several possible causes for any of the error message listed above. Some possible causes are;
1) Incompatibility issues specific to the version of Microsoft Office installed on your computer,
2) The SharePoint Support component or Windows SharePoint Services Support (as appropriate to your version of MS Office) is not installed on your computer,
3) The Owssupp.dll file is not registered correctly in Microsoft Windows and/or is corrupt due to installation of Office 2003 professional, and any of Office 2007 Products
4) You are using Microsoft Office 2010 and do not have a 64-bit version of ActiveX Control installed on your computer.
It is recommended that you consult your Site Administrator before performing any of the resolution options listed below.
Repair a Corrupt Owssupp.dll: Running a Microsoft Office diagnostic tool can repair a corrupt .DLL file. Below are the instructions to run the diagnostic tool.
1. Navigate to C:\Program Files\Microsoft Office\Office12
2. Delete the OWSSUPP.DLL file from this directory.
3. Click Start.
4. Click All Programs.
5. Click Microsoft Office.
6. Click Microsoft Office Tools.
7. Run Microsoft Office Diagnostic.
8. Repair office installation using below instructions
If Office 2003 is installed on the computer:
1. Click Start, and then click Control Panel.
2. Click Add or Remove Programs.
3. In the list of currently installed programs, click Microsoft Office 2003, and then click Change.
4. Click Add or Remove Features, and then click Next.
5. Click to select the Choose advanced customization of application check box, and then click Next.
6. In the Choose update options for applications and tools box, expand Office Tools, click the down arrow next to Windows SharePoint Services Support, and then click Run from My Computer.
7. Click Update.