locked
Person or Group column RRS feed

  • Question

  • Hi:
     Person or group column when set for multiple selection selection to be true does not get exported to spread-sheet. Instead it goes greyed out.
    Even i tried Data-Sheet View to look for this but no gain.

    Any idea what could be wrong.Is this been reported as Bug by MS??

    Thanks,
    Mukesh Giri
    Wednesday, April 29, 2009 10:36 AM

Answers

  • Hello,

     

    Please note the prompt while creating a Person or Group field with multiple section enabled:

     

    Earlier versions of client programs might not support a Person or Group field that allows multiple selections. Adding this field might block those programs from saving documents to this library.

     

    It is known behaviors for Microsoft Excel 2003 and Microsoft Excel 2007 users to export the list with such fields, as below:

     

    For Microsoft Excel 2003 users: The list will NOT export to a spreadsheet if the view used contains any of the multiselect columns. The following error message is produced:

     

    Cannot get the list schema column property from the SharePoint lists.

     

    For Microsoft Excel 2007 users: The list will export to Excel. However, any multi-select column in the spreadsheet contains extraneous data in the form of # delimiters, IDs, and numeric values.

     

    Thanks.

     

    Best Regards,

    Lionel

    Monday, May 4, 2009 8:21 AM

All replies

  • Hello,

     

    Please note the prompt while creating a Person or Group field with multiple section enabled:

     

    Earlier versions of client programs might not support a Person or Group field that allows multiple selections. Adding this field might block those programs from saving documents to this library.

     

    It is known behaviors for Microsoft Excel 2003 and Microsoft Excel 2007 users to export the list with such fields, as below:

     

    For Microsoft Excel 2003 users: The list will NOT export to a spreadsheet if the view used contains any of the multiselect columns. The following error message is produced:

     

    Cannot get the list schema column property from the SharePoint lists.

     

    For Microsoft Excel 2007 users: The list will export to Excel. However, any multi-select column in the spreadsheet contains extraneous data in the form of # delimiters, IDs, and numeric values.

     

    Thanks.

     

    Best Regards,

    Lionel

    Monday, May 4, 2009 8:21 AM
  • Hi Lionel:

    Thanks very much for the explanation.
    This is what i was looking for as confirmation which when i tried with Excel 2003 and 2007 had got the same errors.

    Cheers,

    Mukesh Giri
    Saturday, May 9, 2009 5:54 AM
  • Is there a way to get rid of this #ID text in excel export?

    Be it a script!!!

    Thursday, November 3, 2011 7:02 PM