HI,
That is very strange. When I run this program:
[pre]
ods tagsets.excelxp file='mywb.xls' style=statdoc;
ods tagsets.excelxp options(sheet_name='Lucy' sheet_interval='proc');
proc tabulate data=sashelp.class;
class age sex;
var height;
table sex,age,
height*(min mean max);
run;
ods tagsets.excelxp options(sheet_name='Ricky' sheet_interval='proc');
proc tabulate data=sashelp.class;
class height sex;
var age;
table sex,height,
age*(min mean max);
run;
ods tagsets.excelxp close;
[/pre]
using SAS 9.2, I get one workbook (mywb.xls) with two worksheets. I suggest that you check your SAS log for errors and, if there are no errors in the LOG, if your code still continues to give you a workbook for each procedure, then you should consider contacting SAS Tech Support for more help.
cynthia