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..
