RSS

DATASHEET ISSUE WITH SHAREPOINT

01 Jul

SYMPTOMS:

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.

CAUSE:

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.

RESOLUTION:

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.


Advertisements
 
Leave a comment

Posted by on July 1, 2011 in Office Integration, Sharepoint

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: