I am tyring to get drill down hyperlinks in excel format to work. I have no problem drilling down in HTML format.

Well, what's not working?

This example from the documentation works for me.

TABLE FILE CAR
HEADING
"SALES BY COUNTRY"
SUM SALES 
BY COUNTRY 
BY CAR 
BY MODEL
WHERE (COUNTRY EQ 'ENGLAND') OR (COUNTRY EQ 'ITALY') OR (COUNTRY EQ 'FRANCE');
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET STYLE *
TYPE=REPORT, FONT=ARIAL, TITLETEXT=SALES REPORT, $
TYPE=DATA, COLUMN=COUNTRY, FOCEXEC=DRILLFEX (PARAM1=COUNTRY PARAM2=CAR),$
TYPE=DATA, COLUMN=SALES, COLOR=RED, BACKCOLOR=YELLOW, WHEN=SALES GT 10000,$
TYPE=DATA, COLUMN=MODEL, BACKCOLOR=YELLOW, WHEN=SALES GT 10000,$
TYPE=HEADING, FONT=ARIAL BLACK, COLOR=RED, BACKCOLOR=SILVER, SIZE=16, $
TYPE=TITLE, FONT=ARIAL, SIZE=12, $
ENDSTYLE
END

Move your cursor over the hyperlink to verify what the drill-down URL looks like, and provide us more details about what's not working.

are you trying to drilldown in excel or exl2k? I believe most features don't work in excel ... you would need to use exl2k.

David, make sure you have specified the full URL of the wf server engine to your drilldowns.
Its often the forgotten thing...
Easiest way to do that is at the top of your fex,
SET FOCEXURL = http:\\servername\...
whichever engine you're using, WFservlet or webapi.dll...
Doing so won't affect your html versions, and will enable your other-output-format versions, including emailed html tables.
If you have a look at your drilldown url, as Francis says, it might be incomplete, and not know the full location of your wf engine. And as Pam say, verify for us which excel output format you're using.

I am working in exl2k. It sounds like the URL thing is the issue. I will try it and let you know. Thanks to all.

Hi Davidg,

Have you got a chance to try the suggestions? Would you like to share the result with all?

Many thanks for everyone's input.

Cheers,

Kerry