Monday, May 13, 2013

Unable to view list in Data Sheet View in SharePoint 2010


It is imperative that you have Microsoft Office installed in your machine so that you can be able to view a SharePoint list in Datasheet view. You always have 64 bit SharePoint installation. If you have 32 bit Microsoft Office, you don't have any problem. But you won't be able to use datasheet feature if you have 64 bit Office.

No worries. There is solution to every problem. And this one has even easier. Download 2007 Office System Driver Data Connectivity Components.

Caution: This tool must be installed only after you have installed Microsoft Office. If you install this tool first and then setup 64 bit Microsoft Office, it will complain that you have 32 bit Office Component and won't let you install unless you have completely removed the traces of 32 bit Office.

No comments:

Post a Comment