locked
In sharepoint 2003 The choice fields (drop downs) do not appear RRS feed

  • Question

  • In sharepoint 2003 The choice  fields (drop downs) do not appear when we export to MS Excel 2007 (but they do in MS Excel 2003).
    • Moved by Mike Walsh FIN Monday, August 1, 2011 2:21 PM Not Excel Services (From:SharePoint - Excel Services (pre-SharePoint 2010))
    Monday, August 1, 2011 2:03 PM

Answers

  • Hi chittasn,

    Not sure this issue is caused by what, but it also happens to the SharePoint 2007.
    Actually when you patch the sp3 for office 2003, the drop downs also disappear in Excel 2003. And the drop downs are not appear in the Excel 2007 all the time.

    I would suggest you go to Excel forum and ask whether display the dropdown in Excel 2007 for that choice field, and how to display it.
    And you can post a feedback about this issue to the SharePoint Product Team via the following link, whether the choice field can be displayed as the dropdown format in the Excel 2007.
    http://connect.microsoft.com/site428

    Thanks,
    Daniel


    Regards, Daniel
    • Marked as answer by Wayne Fan Sunday, August 14, 2011 8:22 AM
    Friday, August 5, 2011 11:59 AM
    Moderator