19 January, 2016

The list cannot be displayed in Datasheet view

SharePoint and office are the most used components when you start working in an office. Almost 90% of our documents are in office compatibility so it’s quite obvious that they have to work with SharePoint without any issues and if you start facing issues then it’s quite annoying!

Environment details:-
·         SharePoint 2010
·         Office 2013
·         Windows Server 2008 R2

Here is the error message that I am talking about:

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.

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.

Imp Notes:
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.


If you have any queries / questions then please let me know. I would be more than
happy to help you as well as resolves your issues, Thank you!


  1. Devops is not a Tool.Devops Is a Practice, Methodology, Culture or process used in an Organization or Company for fast collaboration, integration and communication between Development and Operational Teams. In order to increase, automate the speed of productivity and delivery with reliability.

    python training in bangalore
    aws training in bangalore
    artificial intelligence training in bangalore
    data science training in bangalore
    machine learning training in bangalore
    hadoop training in bangalore
    devops training in bangalore

  2. Gaining Python certifications will validate your skills and advance your career.
    python certification


  3. Packers And Movers Bangalore Local Household Shifting Service, Get Free Best Price Quotes Local Packers and Movers in Bangalore List, Compare Charges, Save Money And Time at
    Local Packers And Movers Bangalore


Your feedback is always appreciated. I will try to reply to your queries as soon as possible- Amol Ghuge

Note: Only a member of this blog may post a comment.