EXL2K saves as .XLS but format is really webpage/.mht

[sagobogger]

I'm having a problem with a Managed Reporting (web client) compound EXL2K format report that saves as a .XLS suffix file, but is really a "single file webpage" format file. This is transparent to later versions of Excel on the PC but causes problems on mac. I can fix it by opening it in Excel and forcing it to save as Excel (incidentally reducing the file size to 1/3).

Has anyone else seen this problem?

 

[focwizard]

Can you save your output FORMAT EXCEL? That creates an XLS format file.

 

[sagobogger]

Unless I'm missing something I don't think FORMAT EXCEL will produce a compound/multitab report. (I didn't mention it above but it also has formulas.)

 

[thegrinder01]

Yep, have had the exact same thing for about 3 years! I'm afraid I don't know how to fix it though.

Might be worth contacting Information Builders directly.