Skip to Content
0
Former Member
Nov 25, 2013 at 11:05 AM

Exported webi report in BOXI 3.1 SP 5 as XLSX but excel 2010 cannot open it

27 Views

Hi Guys,

We recently upgraded from BOXI R3.1 SP3 to SP5.

CASE 1:

In Infoview when i save the report to excel, i don't get OPEN, SAVE, CANCEL options anymore. I have to save the report to view it.

Is there any way to open the report without saving to excel? Or is this the way it is in SP5?

CASE 2:

I am not able to export WEBI report to EXCEL 2007 option (XLXS). Later when i increased the char size in CMC from 5 to 100, i was able to save in xlxs format.

However, i am not able to open the saved excel file. It gives me this message.

"Excel cannot open ''DEF.XLSX' the file 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"

How can i open the xlxs file?

Any suggestions or answers would be very helpful.

Thanks

Shreyas