I am using obiee11g.I have one table report.I have to export this into excel sheet.When i am doing export after few rows inserted then it retrun error
like "Report_Name(1).xls is in a different than specified the file extension.Verify that the file is not corrupted and is from a tructed source before opening the file.Do you want to open the file now"
Just read in a blog , it's not a issue with OBIEE but with Excel 2007 .
You can give it a try with the following :
insert this key in your registry to suppress the notification:
Open your Registry (Start -> Run -> regedit.exe)
Navigate to HKEY_CURRENT_USER\SOFTWARE\MICROSOFT\OFFICE\12.0\EXCEL\SECURITY
Right click in the right window and choose New -> DWORD
Type “ExtensionHardening” as the name (without the quotes)
Verify that the data has the value “0?
Let me know the results !!