Click here to Skip to main content
15,888,610 members
Articles
Tip/Trick
(untagged)

Error: SharePoint List Cannot be Displayed in Datasheet View

Rate me:
Please Sign up or sign in to vote.
5.00/5 (2 votes)
22 May 2012CPOL 17.1K  
The list cannot be displayed in Datasheet view

Introduction

Does anyone receive the following error when you try to enable "Datasheet View" under any List?

=========================================================================
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.
=========================================================================

Reason

It happens if you install 64-bit Office 2010 on the Server. Why?
A 64-bit version of the Datasheet component is not available for Office 2010.

Solution

You can install the 2007 Office System Driver: Data Connectivity Components to enable the Datasheet component. It will work with the 64-bit version of Office 2010 as long as you are using a 32-bit version of an Internet browser.

URL: 2007 Office System Driver: Data Connectivity Components

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
Architect Brain Station-23
Bangladesh Bangladesh
Ferdous has industry level experience with SharePoint and has done several presentations and workshops on SharePoint. He also worked as SharePoint Consultant (CREDEM Italy, Robi etc) and Trainer (BASIS, JAXARA IT, LEADS Co.). He is currently working as SharePoint Architect at BrainStation-23. He also worked as Technical Project Manager for Congral LLC for managing revolutionizing Patient Centric Healthcare applications at the same company since 2009.

He worked on many international projects during his professional life. The major projects are included below:
Internal Enterprise Portal for Robi, Dhaka
nVision Solution for nSales A/S, Denmark
Shared Care Plan for Congral LLC, USA
Internet Banking Portal for the Bank of CREDEM, Italy
Document Management (DMS) for the Bank of CREDEM, Italy
MES solution for Rockwell Automation, Italy
Tourism for Travel Curve Inc., USA
and so on...

He is the author of several technical articles with over 49 articles published on http://mrbool.com where he is the Technical Author for the site and author of mssharepointtips.com as well. He is also founder of SharePoint Expert group.

Looking for a Offshore Development or partnership.............. in any development in Dot.Net & Sharepoint 2007,2010 Platform.

Search him in google by 'MJ Ferdous' to get all links, articles, profile etc

Contact him: ferdouscs@gmail.com mjferdous@live.com

Blog: http://geekswithblogs.net/ferdous

Specialties
===========
Production troubleshooting, maintainability and scalability
SharePoint 2007/2010
Dot.Net Application
Project Management
Document Management Solution

Comments and Discussions

 
-- There are no messages in this forum --