Tuesday, February 15, 2011

Cannot Display the List in Datasheet View

I recently set up and configured a SharePoint 2010 Enterprise Server on a VMware with Windows 2008 R2 Server as a development machine. The SharePoint Server has both Excel Services and PowerPivot Services installed and running without issues.  During testing the functionality of the SharePoint Server, I encountered the follow error while clicking on the Datasheet View button on the List Tools:
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.
This error indicated a component that required to display the Datasheet View is missing. Since I did not install any Microsoft Office Clients on the server such as Microsoft Word or Microsoft Excel, I will need to install the 32-bit version of Microsoft Office System Driver: 2007 Office System Driver: Data Connectivity Components to enable the Datasheet component.
After the component installed, the list could be displayed as a datasheet now.  This solution will work with the 64-bit version of Office 2010 as long as I am using a 32-bit version of an Internet browser.
Note:  If you are using a 64-bit version of an Internet browser, for example the 64-bit version of Microsoft Internet Explorer 8.0, there is no support for the Edit in Datasheet feature.
More information about this issue could be found:


  1. It is often happened that we have to face some problems in the internet connection.And for this here have several this that how to get rid of this things.So i will like to learn this and will do if i face any problem in here.

    Desktop PCs

  2. I as well as my friends were reviewing the nice procedures located on your web site and so all of the sudden developed a horrible feeling I never expressed respect to the blog owner for them. All of the guys are already consequently thrilled to read them and already have without a doubt been enjoying them. We appreciate you turning out to be simply kind as well as for making a decision on variety of decent useful guides most people are really needing to learn about. My very own sincere regret for not saying thanks to you earlier.
    Gaming Cases