SharePoint Datasheet View and Office 2010 64-bit

If you have installed the 64-bit new version of Microsoft Office, Office 2010, then you will most likely see the following message when trying to edit a SharePoint list using the Edit in datasheet function:

The list cannot be displayed in Datasheet view for one or more of the following reasons:

– A datasheet component compatible with Windows SharePoint Services is not installed.

– Your Web browser does not support ActiveX controls

– Support for AxtiveX controls is disabled


The issue revolves around the fact that 64-bit versions of Office 2010 do not ship with the 32-bit Activex control that would make the datasheet option work with Internet Explorer.
There are ways to make this work, and the usual suggestion is to find a copy of an Office 2007 product and either install it (such as SharePoint Designer 2007) or just choose to install the Windows SharePoint Services components of the product. This works, but I don’t really want to go to that much trouble.
Another solution, and the one that I employed, is to install the 2007 Office System Driver: Data Connectivity Components. After installing the Components, go back to the menu and the datasheet option will work great.

Mobile View Doesn’t Work on SharePoint ( WSS 3.0) List

I recently ran into a situation where I couldn’t get the ‘Mobile View’ in WSS 3.0 to work on a list that I had created. I went into the view of the list and selected the Mobile checkboxes (‘Make this a mobile view ‘ and ‘Make this the default mobile view‘), but it still was not showing up on my SharePoint site’s mobile homepage. My first thought was “What makes this list different than the other lists that have mobile views that are working?”

The answer was easy: I had created the list by selecting Custom List in Datasheet View from the ‘Create’ page. There are no mobile view choices for datasheet views, so I had created a new ‘standard’ view for the list. Even though I could check the ‘ Make this a mobile view ‘ checkbox, it was not showing up on the mobile homepage.

I basically had to recreate the list using the Custom List option, instead of Custom List in Datasheet View option. This is likely a bug; I haven’t been able to come up with a reasonable explanation as to why it would act this way (and the fact that the Mobile options showed up reinforce my bug theory).