We are using Webfocus 8.1 and getting an error trying to open the .xlsx files, it says "Excel cannot open the file "kvxnn.xlsx" because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file."
This worked fine with 8.0 version. I am not aware on if there is a setting that needs to be changed and where. Can someone point me in the right direction ?

Thank you.

This message has been edited. Last edited by: <Emily McAllister>,

Starting with Excel 2007 you'll get this error if the file extension does not match the actual format of the file. This is a security feature added beginning with Excel 2007.

We most commonly see this if a program is creating a report with "FORMAT EXL2K" and they are trying to open the report in Excel 2007 or higher. WebFOCUS does not create true .xls files. Therefore when one tries to open the file, the extension (.xls) does not match the internal format of what Excel expects in a .xls file.

This could also happen if you are delivering a report from a Report Caster job via email and the report contains an embedded macro. .xlsx files cannot contain macros, so again the contents do not match what Excel expects for a .xlsx file. If this is the case, check the RC job and make sure the task is delivering a .xlsm file and not a .xlsx file.

There are other ways to get this as well but basically Excel is telling you that you are trying to open a .xlsx file and the internal format is not that of a .xlsx file.

The first case requires a registry change or you have to convert the report to "FORMAT XLSX".

smagdi,

If you are already using FORMAT XLSX, then I would consider adjusting your redirection settings in the administration console. You want to make sure that xlsx files are saved before being sent to the end user.

Try reading the following and see if that helps: http://infocenter.ibi.com/wf81.../source/topic108.htm

We have found that it helps if you include in a procedure the following code:

 SET EXCELSERVURL = '' 

Or you can change it in the Admin Console

 IBIF_excelservurl = ''