When you try to open a file that you exported to Microsoft Office Excel 2007 or Microsoft Office Excel 2010 from Microsoft Dynamics CRM, you receive the following warning message:
The file you are trying to open, File_name.xls is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now?Note The File_name.xls placeholder is a placeholder for the name of the file that you want to open.
This problem occurs if the following conditions are true:
You exported one of the following types of worksheet from Microsoft Dynamics CRM:
The view from which you exported the worksheet contained at least one record.
This problem occurs because Microsoft Dynamics CRM exports the records as an .xml file. Because Excel 2007 also adds an .xml file filter, the .xml file has a different file type than the original file when Excel opens the .xml file.
To work around this problem, click Yes in the dialog box that contains the warning message. You can safely ignore the warning message.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.