Anybody has this issue. When I choose Excel as the export type, it doesn't export to Excel file, it just opens report in the excel format in the iframe I put in HTML file.

This message has been edited. Last edited by: <Kathryn Henning>,

What's your HOLD line? "ON TABLE PCHOLD FORMAT EXL2K"?

Yes Doug, that is my HOLD file.

this doesn't seem to be an excel problem, but rather a target problem
you seem to have a launch page that specifies the output of your fex to be in an iframe.
so, regardless of the output format (just a variable to the fex), the report is going to come out in that iframe. Try it with PDF to see what i mean.
so... without a load of agita...
i no longer put output options into launch pages, not when i'm using iframes or frameset frames.
instead, i put icons in the report heading
an Icon for excel(that nice green x), an icon for pdf (a nice red one), a pushpin for frozen column titles, and that blue A for active reports ...
Each of these icons has a link under it, just like any other drilldown.
and in the style sheet
TYPE=HEADING,LINE=1,ITEM=1,TARGET=BLANK,FOCEXEC=thesameone(&WFFMT=EXL2K),$
TYPE=HEADING,LINE=1,ITEM=2,TARGET=BLANK,FOCEXEC=thesameone(&WFFMT=PDF),$

Maybe take a look at this post?:
http://forums.informationbuild...827011216#5827011216

In the example, if the requested format is Excel then the target is set to an iframe with a display of none.

One that is done, the servlet is called (via a hidden run form).

If I understand your scenario correctly, you'd be looking at the

<iframe style="POSITION: absolute; DISPLAY: none;"
         id=iframe1 tabIndex=2
         autoExecute="False"
         name="ifrmExcel">
</iframe>  

and

  
document.hiddenRunForm.target = "ifrmExcel";
...
document.hiddenRunForm.submit();