Showing posts with label Datasheet View. Show all posts
Showing posts with label Datasheet View. Show all posts

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.
image
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.
 image 
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.
image
More information about this issue could be found: