Columns disappearing in DataSheet
My client is having a problem with the SharePoint DataSheet view. Some columns just disappear when switching (Edit in Datasheet) and reappear when getting back to standard view.
The server is running MOSS 2007 SP1 Entreprise.
Only computers running Office 2003 suffer from this problem. Computers running Office 2007 are running fine.
With this information in mind I would expect the problem to come from the client side, and indeed tracing the HTTP with Fiddler I found out that the missing columns information seems to be sent to the client in the ActiveX xml beginning with:
RenderActiveX(“u003cOBJECT id=u0022STSListControlWPQ2u0022 name=
I have yet to find a solution to this problem. As you guess, the client wouldnt consider installing Office 2007 on every single computer to be a solution:)
Any idea ?
Thanks in advance, Jonathan
September 14th, 2009 2:37pm
The information displayed in SharePoint datasheet view is shown in an ActiveX control built into the client side STSLIST.DLL. The reason for this issue might be that the ability to display certain types of information is not available in Office 2003 and is new to Office 2007.
In order to have all columns displayed in SharePoint datasheet view, I think that you need to have an Office 2007 feature 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”. The “Windows SharePoint Services Support” feature act as a sub-feature of “Office Tools” and it is only in most SKU of Office 2007. That is, this feature is not included insome of the simple application SKU like OneNote, Visio, and Project.
September 16th, 2009 4:54am
Hi Lily, Seems like you were right, except that the problem is not with the type of the columns itself but with the multi-value some columns can have. Some Person columns dissapear, others aredisplayed. Same for the lookup columns. But all columns disappearing allow multiple values. So my problem would come from the fact that the Office 2003 “Microsoft Office List DataSheet Component” feature is not able to display multi-valued column contrary to the Office 2007 “Microsoft Office Access Web Datasheet Component”. I have yet to find an official document backing up this shortcoming. The “Microsoft Office programs and SharePoint Products and Technologies Integration – Fair, Good, Better, Best” whitepaper doesn’t tell anything about this difference. Thanks a lot
September 16th, 2009 9:50am
Ok so the problem definitely came from multi-valued columns.I tried installing the component refered to by Lily ( “Microsoft Office Access Web Datasheet Component”) from an Office 2007 Enterprise install without installing Work, Excel, … 2007.Seems like the Office 2003 suite is working OK and the DataSheet view indeed allows me to view the multi-valued columns.Might be the solution for my client as Office 2007 licenses are not a problem to him.Thanks LilyBest Regards,Jonathan
September 16th, 2009 12:13pm
What you also can do, if you don’t like to install Office 2007 is installing the AccessRuntime environment. After the installation SharePoint will use Access for the datasheet view and also muli-valued columns can be edited.
Read the solution some time back but wasn’t able to find it again in the web. Saved file helped me to recover it. So, to spare some others the research:
Just installing Microsoft Office Access Web Datasheet Component from Office 2k7 CD also works fine, but i’m not quite sure if you need a license.
April 7th, 2010 11:29am
This topic is archived. No further replies will be accepted.