Showing posts with label Cannot Edit SharePoint 2007 List in Datasheet after Office 2010 is Installed. Show all posts
Showing posts with label Cannot Edit SharePoint 2007 List in Datasheet after Office 2010 is Installed. Show all posts

18 January, 2011

DataSheet views in Sharepoint 2007 don't work with Office 2010



I have installed Office 2010 (64 bit) in my windows 7 machine and did some testing with sharepoint 2007 sites.

As list and document libraries are the most common used components in SharePoint sites so i had started my testing with these ones and found out one problem /error message which takes some time to resolved it completely.

I would like to share my resolution with all of you so that you do not have to waste your time while digging the same problem.

I went to my SharePoint 2007 site and tried to edit a custom list in datasheet view. I’ve got an above mentioned error message :

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

Resolution:

Various editions of Microsoft Office 2007 include SharePoint support component, which is installed by default:

-Microsoft Office
-Office Tools
-Windows SharePoint Services Support.

Specifically the “Edit in datasheet” feature is supported by the sub-component named “Microsoft Office Access Web Datasheet Component”. I went and checked out the components installed for my Office 2010 – and the various unnecessary components were marked as installed:

What you have to do:

install back Windows SharePoint Services Support for Office 2007. Below is a screen shot – I only needed this specific part of the office and nothing else:




Now the “View in Datasheet” worked for me.

If you have any queries/questions regarding the above mentioned information then please let me know, Thanks..