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:
SharePoint:
ActiveX Error When Trying to View List in Datasheet View: http://weblogs.asp.net/felipeferreira/archive/2009/07/30/sharepoint-activex-error-when-trying-to-view-list-in-datasheet-view.aspx
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
Good article, it helpmed me alott!!!
ReplyDeleteThank you so much.
--Maximus