Export to Excel RRS feed

  • Question

  • CRM experts,


    Export Data to Excel only provides me to save to one option, Excel 97 - 2003. This is odd because my computer is W7, with office 2010. Anyone know if there is a setting to allow it to save to a later version?


    Thanks so much for any tips here,


    Earl Stoddard...

    Friday, September 2, 2011 2:00 PM


All replies

  • Hi,

    Dynamics CRM Export to excel only export data into Excel 2003 XML Spreadsheet format to make it compatible with Office 2003/2007 and 2010. There is no supported way to change the export file format while exporting data. What you can do is after exporting data you can open the excel file in Office 2010 Excel and then can Save As the file in Office 2010 file format.  

    Jehanzeb Javeed

    Linked-In Profile |CodePlex Profile

    If you find this post helpful then please "Vote as Helpful" and "Mark As Answer".
    • Proposed as answer by Jehanzeb.Javeed Friday, September 2, 2011 2:11 PM
    • Marked as answer by EStoddard Friday, September 2, 2011 2:15 PM
    Friday, September 2, 2011 2:10 PM
  • No.  There isn't an option to export to the newer version of office.  But at least the newer version of office works with the older file type.
    Jamie Miley
    Check out my about.me profile!
    Linked-In Profile
    Follow Me on Twitter!
    Friday, September 2, 2011 2:11 PM
  • That just looked odd, being it is Microsoft, that they would use an older version in their export function.


    Thanks so much...That makes sense.

    Friday, September 2, 2011 2:15 PM