In reply to Rick Wicklin.

Thank you Rick for your email. However i would like to check with you again before i try it.

The existing code looks like below

ods exclude all;
ods tagsets.excelxp file='~path';
proc report data = test nowd ;
column ............;
define ...............
run;
ods tagsets.excexp close;
ods exclude none;

Could you please guide me on the further change.

Thanks,
Jagadish