Hi ameey, Please be specific, as i understand you have tow problem mentioned: 1. The pop message -->If you run the msoffice2k_x.sas succesfully when starting your SAS session, then creating your EXCEL sheet. You will not face the pop message that bothering you. 2. The rename of the sheet other than the default in MS Excel -->You can rename the sheet by setting the sheet_name options as you want, but you can not set it to null "" because MS Excel not allowing that and if you did so it will be set to the default by MS Excel when you open it as "sheet1". So for now, kindly do the following : 3.1. Open new SAS session. 3.2. Run the msoffice2k_x.sas 3.3. Run the following example code: ods tagsets.msoffice2k_x file="c:\temp\worksheetoption.xls" style=normal options( zoom="70" fittopage="yes" sheet_name="Ameey Sheet" tabcolor="yellow" pagebreaks="no" embedded_titles="no" embedded_footnotes="no" ); proc print data=sashelp.prdsale(obs=50); run; ods tagsets.msoffice2k_x close; 3.4. after that open the excel and you will find the sheet name as "Ameey Sheet". Please reply by what you find.
... View more
