OBIEE 11g - Error Received in Excel 2007 when Attempting to Open Exported Analysis: "The file you are trying to open is in a different format than specified by the file extension" (Doc ID 2062395.1)

Last updated on JANUARY 31, 2017

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.7.1 and later
Information in this document applies to any platform.

Goal

After exporting an Analysis from OBIEE, this message can occur when trying to open it in Excel 2007:

"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 isn't corrupted and is from a trusted source before opening the file, do you want to open the file now?"

When the user clicks 'Yes', it displays this message:

"The file is corrupted and cannot be opened"

Why does the error appear?
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms