The list cannot be displayed in datasheet view - SharePoint 2010

2019-04-25

Question

_{Thursday, April 25, 2019 4:45 AM}

Hi All,

I am accessing the SP 2010 version with Office 2016 64 bit and Win 10 in our local machine. We are getting below error:

[The list 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 Web browser does not support ActiveX Controls. A component is not properly configured for 32-bit or 64-bit support.]

Can any one help on this if any patch or add in required?

Rohit Dixit, SharePoint Admin

All replies (2)

_{Thursday, April 25, 2019 7:04 AM ✅Answered | 1 vote}

Hi, Rohit,

I will list needed configuration to enable datasheet view below. Please have a check on them:

The datasheet component isn’t available in 64-bit versions of Office. You will need to have 32-bit versions of Office.
You can only use 32 bit version of IE 11 to use this component. And you need to enable ActiveX controls in Internet setting. For detailed steps, please check this thread: https://stackoverflow.com/questions/26151999/ie11-prevents-activex-from-running
Add the SharePoint site to trusted site.
Make sure your IE enabled the Office addon: Microsoft Office List 1x.0. Open Internet Explorer, select the Tools button , and then select Manage add-ons. Under Show, select All add-ons and check.

Best Regards

Jerry Xu

Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact [email protected].

SharePoint Server 2019 has been released, you can click

here to download it.
Click

here to learn new features. Visit the dedicated

forum to share, explore and talk to experts about SharePoint Server 2019.

_{Tuesday, April 30, 2019 8:00 AM}