I'm having the same problem as Karen.
Using Excel XP tagset v1.116, Office 2007
%IF &TYPE_OP=EXCEL %THEN %DO;
%let RV=%sysfunc(appsrv_header(Content-type, application/vnd.ms-excel));
%let RV=%sysfunc(appsrv_header(Content-disposition,%str(attachment; filename=temp.xls)));
ODS _ALL_ CLOSE;
ODS TAGSETS.EXCELXP
FILE=_webout
OPTIONS(GRIDLINES='YES'
AUTOFILTER='NONE'
FROZEN_HEADERS='YES'
SHEET_INTERVAL='NONE'
EMBEDDED_TITLES='YES'
) style=sasweb;
%REPORT_PRINT;
%web_cnt;
ODS TAGSETS.EXCELXP close;
%END;
... View more
