MS Sharepoint – Sharepoint List – Unable to Edit in DataSheet – The Standard View of your list is being displayed because your browser does not support running ActiveX controls

MS Sharepoint – Sharepoint List – Unable to Edit in DataSheet – The Standard View of your list is being displayed because your browser does not support running ActiveX controls

MS suggests the following culprits:

  • 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 Active X controls and/or support for Active X Controls is disabled

Here are some credible links:

  1. Install Microsoft Office XP or later
    http://support.microsoft.com/kb/833714
  2. Make sure that SharePoint support is installed as part of MS Office
    http://support.microsoft.com/kb/833714
  3. Register the Owssupp.dll file
    http://support.microsoft.com/kb/833714
  4. Running a repair of Office 2003 or Office 2007
    http://support.microsoft.com/kb/833714
  5. Launch Control Panel \ Internet Options, then to the Advanced tab, and clicked Reset. After IE was reset to default, it finally worked for some.
  6. Re-register owssupp.dll
    http://www.novolocus.com/2007/11/29/stupid-bloody-owssuppdll/
  7. If you ‘re using MS Office 2007 or later, make use of Office Diagnostics
    http://www.makeuseof.com/tag/how-to-detect-and-fix-ms-office-problems-using-ms-office-diagnostics-windows/
  8. Determine the Internet Explorer Zone that the web site is in — Ensure that Active X is enabled per this site.  Preferable, the web site is in the “Trusted” or “Local Intranet” zone.
  9. Ensure that you are running Professional version of Office, and not Standard Edition
  10. If you are using MS Office 2003, Install MS Office 2003 Web Components
    http://www.microsoft.com/downloads/details.aspx?FamilyId=7287252C-402E-4F72-97A5-E0FD290D4B76&displaylang=en

Suggested Readings: