Showing posts with label SharePoint Columns not visible in datasheet view. Show all posts
Showing posts with label SharePoint Columns not visible in datasheet view. Show all posts

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