Resolve Datasheet View Issues in SharePoint 2007



Solution

The following is the solution for “A datasheet component compatible with Windows SharePoint Services is not installed".

Windows SharePoint Service Support options for Microsoft Office should be installed (applicable to Office2003 as well as for Office 2007).

To enable this option:

  1. Pres the Start button then select Control Panel then go to Add or Remove Programs then click on Microsoft Office and then Change.
  2. Add/Remove Features.
  3. Expand the Office Tools category.
  4. Next verify that you have both the Microsoft Office Access Web Datasheet Component and the Windows SharePoint Services Support component installed.
  5. If these components are not installed then choose to run them from your computer and then click the Continue button and go through the installation process.

Please find the process in Windows 7 using the following screenshots.







Solution

The following is the solution for “Your Web Browser does not support ActiveX controls” and “Support for ActiveX controls is disabled”.

  1. You need to verify that you can run ActiveX controls in Internet Explorer. To do this open IE and go to the Tools menu then select Internet options.
  2. Next click on the Security tab and for your Trusted sites click (choose Internet if you do not add your SharePoint sites to your Trusted Sites) on the Custom level button.
  3. Verify that you can use previously unused ActiveX controls.
  4. Verify that you can download signed ActiveX controls and that you can run ActiveX controls and plug-ins.
  5. The next setting is select "Enable" for Script ActiveX controls marked safe for scripting.
  6. Adjust these settings accordingly and then click OK twice to return to Internet Explorer.
  7. You may need to close Internet Explorer and re-open it before your new settings take effect and become active.

Additional Solution

Solution 1

You need to install “2007 Office System Driver: Data Connectivity Components” on each client workstation / PC that has a 64bit version of Office installed. This install will put the necessary ActiveX components on your workstations to allow SharePoint Datasheets to be used with 64-bit versions of Office.

Download from Microsoft at http://www.microsoft.com/en-us/download/confirmation.aspx?id=23734

Solution 2

Ensure you use the 32 bit version of Office. The datasheet view does not support Office in 64 bit. To determine the version of your Office installed in the system use the following procedure.

In Office 2010

First, open any Office application. In this example, we're using Word 2010, but it works the same in the other Office apps. Open the File menu and then select Help.



On the right side, you'll see information about your version of Office. It will show the suite version and included applications, as well as your precise version number and product ID.



In Office 2013

File-> Account and see about Word/Excel/Power point