24 December, 2011

Sharepoint list columns not visible in datasheet view


Display a list in Datasheet view. Datasheet view requires that you have a Windows SharePoint Services-compatible datasheet program installed, such as Microsoft Office 2003 Professional. Datasheet view lets you add, delete, and update list entries just as you would in a spreadsheet program, such as Microsoft Office Excel 2003. Come across such issue that belongs to datasheet view and details are as follows:

ISSUE:
Some list columns are not visible in datasheet view

CAUSE:
This issue can be observed only if following is true:
1. Office 2003 is the primary office package installed at user workstation
2. List contains columns in which multiple values are allowed.

Multi-valued columns are not visible in datasheet view if you have office 2003 installed.

This is a by-design behavior.

RESOLUTION:
Any of the following is applicable to resolve this issue:
1. A feature needs to be installed called "Microsoft Office Access Web Datasheet Component". This feature can be found in the installation UI as a sub-feature of "Windows SharePoint Services Support".
2. Install “Access Runtime” which can be found http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=4438
3. Upgrade office package to version 2007

If you have any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, thank you

References:


Cannot edit lists in Datasheet view

 SharePoint 2007: Use the Datasheet View to Add, Edit, or Delete Items and Files: http://programming4.us/enterprise/2402.aspx

1 comment:

  1. Good article, it helpmed me alott!!!
    Thank you so much.

    --Maximus

    ReplyDelete

Your feedback is always appreciated. I will try to reply to your queries as soon as possible- Amol Ghuge

Note: Only a member of this blog may post a comment.