Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Question
Monday, June 10, 2013 4:15 PM | 1 vote
I have 2013 Office installed and using 2010 SharePoint Foundation.
The button 'Datasheet View' is available on the site but when clicked on I get this 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.
I have installed and repaired the Office Suite already, ActiveX is enabled in the browser etc.
I have also enabled the Microsoft Add-ons.
Installed on Windows Server 2008 R2.
How can I solve this issue?
All replies (15)
Monday, June 10, 2013 10:59 PM âś…Answered | 19 votes
To resolve this you need the following data connectivity component installed: http://www.microsoft.com/en-us/download/details.aspx?id=23734 Although this says 2007 and therefore looks like an odd install in relation to 2010 SharePoint it resolves this data sheet issue.
Brendan Lee
Monday, June 10, 2013 5:12 PM
It might be that you're using the 64-bit version of Internet Explorer. If you are, change it to the 32-bit version.
cameron rautmann
Monday, June 10, 2013 6:33 PM
Hi,
1. The Edit in Datasheet view functionality in SharePoint Server 2010 is not supported if you install 64-bit Office 2013 client. The Edit in Datasheet functionality is available if you install 32-bit Office 2013 client
http://technet.microsoft.com/en-us/library/ee681792.aspx
2. Edit in data sheet view is not supported in 64 bit version of the i.e.
If I understand correctly you are trying to access site from the Windows server 2008 R2, the default OS installation will have two browsers. Open internet explorer that doesn't have (64 bit) in the bracket. The one with 64bit is not supported
Regards Murali
Tuesday, June 11, 2013 9:00 AM
Hi Brendan,
Will this involve a system reboot or will it install in the background with no reboot required?
Bjorn
Monday, July 15, 2013 4:55 AM
Hi Branden,
Thanks for your link and help. It's very helpful and I fixed my SharePoint tracker issue. Appreciate you for sharing the valuable knowledge.
Wednesday, March 19, 2014 9:04 PM | 1 vote
I have Office 2013 x64 and after install the connectivity component the problem was solved. Thanks Brendan. Regards.
Wednesday, April 8, 2015 3:03 PM
Thank you. Fixed it instantly.
http://www.microsoft.com/en-us/download/details.aspx?id=23734
Monday, April 27, 2015 9:37 PM
Hello all,
I have a similar problem, I have a List and if I try to modify any row using Datasheet view a can do it with no problems, but later I used a webpart to insert the List in a new page, but in this new page I can't use Datasheet view for the list.
It looks like the problem is not that I don't have a missing component, since I can use datasheet in the list itself, but when I "change the context" to use the list inside the page, it's disabled.
Anyone knows what can be causing this issue?
Thanks in advance, BR,
Jorge Herrera
Thursday, May 14, 2015 9:55 PM
My issue is very similar. I get this error on only one list in our SharePoint 2010. All other lists I've tried in Datasheet View work without problem. (Same computer, same browser.)
Scott Perley
Tuesday, January 19, 2016 9:46 AM | 1 vote
Your Link is version (12.0.4518.1014) published at 2008
the new version (14.0.6119.5000) published at 2013 :
https://www.microsoft.com/en-us/download/details.aspx?id=13255
and you can select 32 or 64 version as your system type.
I can do anything
Tuesday, August 30, 2016 11:52 PM
Worked for me.
Thank you.
Computers - My love
Sunday, October 2, 2016 4:40 PM
Your Link is version (12.0.4518.1014) published at 2008
the new version (14.0.6119.5000) published at 2013 :
https://www.microsoft.com/en-us/download/details.aspx?id=13255
and you can select 32 or 64 version as your system type.
I can do anything
Worked for me to, awesome stuff!
Friday, October 5, 2018 5:43 PM
works great! Thank you
Tuesday, October 23, 2018 8:40 PM
wow, this was sharp!
Wednesday, March 20, 2019 3:31 PM
https://www.microsoft.com/en-us/download/details.aspx?id=13255
worked like charm