none
Columns disappearing in DataSheet

    Question


  • Hi,

     

    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=\u0022STSListControlWPQ2\u0022 name=\

     

    I have yet to find a solution to this problem. As you guess, the client wouldn’t consider installing Office 2007 on every single computer to be a solution:)

     

    Any idea ?

     

    Thanks in advance, Jonathan


     

    • Edited by JonathanRoussel Wednesday, September 16, 2009 8:28 AM Fix : installing Of2007 is NOT a solution
    Monday, September 14, 2009 2:37 PM

Answers

  • Hi

    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 in some of the simple application SKU like OneNote, Visio, and Project.

    Best Regards!

    • Marked as answer by JonathanRoussel Wednesday, September 16, 2009 9:50 AM
    Wednesday, September 16, 2009 4:54 AM
  • 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
    • Marked as answer by JonathanRoussel Wednesday, September 16, 2009 9:50 AM
    Wednesday, September 16, 2009 9:50 AM

All replies

  • Hi

    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 in some of the simple application SKU like OneNote, Visio, and Project.

    Best Regards!

    • Marked as answer by JonathanRoussel Wednesday, September 16, 2009 9:50 AM
    Wednesday, September 16, 2009 4:54 AM
  • 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
    • Marked as answer by JonathanRoussel Wednesday, September 16, 2009 9:50 AM
    Wednesday, September 16, 2009 9:50 AM
  • 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 Lily

    Best Regards,
    Jonathan
    • Proposed as answer by Nikolas Orelly Wednesday, April 7, 2010 11:17 AM
    Wednesday, September 16, 2009 12:13 PM
  • 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:

    http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=d9ae78d9-9dc6-4b38-9fa6-2c745a175aed

    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.

     

    Best Regards
    Nikolas

    Wednesday, April 7, 2010 11:29 AM