Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Export to Excel RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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...

    EStoddard
    Friday, September 2, 2011 2:00 PM

Answers

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

    http://worldofdynamics.blogspot.com
    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
  • Question
    Sign in to vote
    0
    Sign in to vote
    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!
    http://mileyja.blogspot.com
    Linked-In Profile
    Follow Me on Twitter!
    Friday, September 2, 2011 2:11 PM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote

    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.

    EStoddard
    Friday, September 2, 2011 2:15 PM