SharePoint (2003 thru Online): Datasheet View error with Office 365 Pro Plus

Tuesday, July 16, 2019

Datasheet View error with Office 365 Pro Plus

"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.
- A component is not properly configured for 32-bit or 64-bit support".
As Office 2007 end of life was Oct 10, 2017, MSFT stopped sharing the links related to Office 2007 and its components like 2007 Office System Drivers: Data Connectivity Components.

Now a days, many users were using Windows 10 with Office 365 Pro Plus, but still have SharePoint 2007 and SharePoint 2010 sites. When they go to any List and click on Datasheet View, it still shows the above error message.

We searched in MSFT downloads and found links for Access Database Engine for Office 2010 and Office 2016. Installed but didn't work.

Finally we found the download for 2007 Office System Drivers: Data Connectivity Components at the below link and installed.


It worked, without restart of laptop.

Note: Make sure the users are aware of clearing Browser cache and Disk Cleanup to clear the temporary files which causes issues most of the times.

2 comments:

  1. The installation of the package is getting failed. What can I do?

    ReplyDelete
  2. @ss might be local existing office folders. Please try working on removing old office folders from Program Files. Make sure before removing, it might throw different errors if the old apps still exist.
    we did it on almost 50-60 Windows 10 PCs without any issues.

    ReplyDelete