Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

Warning message when you try to open a file that you exported to Excel 2007 or Excel 2010 from Microsoft Dynamics CRM: "The file you are trying to open, [File_name.xls] is in a different format than specified by the file extension"


View products that this article applies to.

Symptoms

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:
    • Static worksheet
    • Dynamics PivotTable
    • Dynamics worksheet
  • The view from which you exported the worksheet contained at least one record.

↑ Back to the top


Cause

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.

↑ Back to the top


Workaround

To work around this problem, click Yes in the dialog box that contains the warning message. You can safely ignore the warning message.

↑ Back to the top


Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

↑ Back to the top


Keywords: kbexpertiseinter, kbprb, kbmbsmigrate, kbtshoot, kbexpertisebeginner, kbmbssales, kbmbscrmonline, kb, kbmbsservice, kbmbsmarketing, kbfreshness2008, kberrmsg

↑ Back to the top

Article Info
Article ID : 946274
Revision : 3
Created on : 4/17/2018
Published on : 4/19/2018
Exists online : False
Views : 294