none
Export To Excel RRS feed

  • Question

  • 1. Created a new Task list (or select an existing one)
    2. Changed the property of the "Assigned To" column to "Allow multiple selections = Yes"
    3. Exported to spreadsheet
    4. Result: All columns will be exported except the "Assigned To" column

    If the property is set to "Allow multiple selections = No" the export works fine. Ialso experienced, when property is set to Yes, the column title is greyed out.

    Any help will be much appreciated. Thuis works fine for mw when i use excel 2007 but giving the above error for excel 2003 with office sp3.

    Regards,

    Mukesh Giri

    • Moved by Mike Walsh FIN Friday, June 5, 2009 10:29 AM admin q (From:SharePoint - Excel Services)
    Friday, June 5, 2009 10:09 AM

Answers

  • Hi Guys:

    I got the answer for this.

    It is actually a bug with excel 2003. Which not only gives problem with assigned field when selected for multiple values but this problem will persist with all the functionality wherein "Multiple" values need to be exported or selected.

    This has been fixed for office 2007.So Moss will work fine with office 2007 for this particular issue.

    Cheers,

    Mukesh Giri
    • Marked as answer by Mukesh Giri Wednesday, June 24, 2009 12:55 PM
    Wednesday, June 24, 2009 12:55 PM

All replies

  • Export to Excel is not an Excel services question - it's standard Admin.

    Moving to Admin.



    WSS FAQ sites: http://wssv2faq.mindsharp.com and http://wssv3faq.mindsharp.com
    Total list of WSS 3.0 / MOSS 2007 Books (including foreign language) http://wssv3faq.mindsharp.com/Lists/v3%20WSS%20FAQ/V%20Books.aspx
    Friday, June 5, 2009 10:29 AM
  • Hi Mike:

    Thanks for the proper placement of thread.But do you idea about my query; if it is incompatible with Excel -2003 could you provie me with a link or some documentation from MS.

    Cheers,

    Mukesh Giri

    Friday, June 5, 2009 11:13 AM
  • Hi Guys:

    I got the answer for this.

    It is actually a bug with excel 2003. Which not only gives problem with assigned field when selected for multiple values but this problem will persist with all the functionality wherein "Multiple" values need to be exported or selected.

    This has been fixed for office 2007.So Moss will work fine with office 2007 for this particular issue.

    Cheers,

    Mukesh Giri
    • Marked as answer by Mukesh Giri Wednesday, June 24, 2009 12:55 PM
    Wednesday, June 24, 2009 12:55 PM