KB43266: "The file you are trying to open, XXX, is in a different format than specified by the file extension..." Error Message Appears When Using exportDocument task to Export to Microsoft Excel 2007 in MicroStrategy Task Framework API

Symptom

The following error message appears in Microsoft Excel 2007 after exporting a document using the task exportDocument in Strategy Task Framework API even though excelVersion=4 is specified in the task url:
 

The file you are trying to open, 'XXX.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: excelVersion is the parameter to specify the version of Excel users want to use the report to convert to. See EnumExcelVersion for details.
excelVersion=4 is for Excel 2007.
 

Cause

This is a known issue in Strategy Task API Framework.
 

Action

Contact Strategy Technical Support for an update on this issue.
 
 

Workaround

In Strategy Web under User Preferences > Export Reports > Excel options, make sure Excel version is set to "Excel 2007 or newer versions" to avoid the error message in Excel.
 
ADDITIONAL INFORMATION: The Strategy SDK allows you to customize the standard Strategy Web interface, and extend and integrate the Strategy business intelligence functionality into other applications. However, before changing the way Strategy Web products look or behave, it is helpful to understand how the application is built.