https://communities.sas.com/t5/SAS-Enterprise-Guide/exprting-excel-without-cell-color/m-p/5191#M1641 Hi:<BR /> Try using different style templates. STYLE=MINIMAL is a very plain style.<BR /> [pre]<BR /> ods msoffice2k file= "/myexcelfile.xls" style=MINIMAL;<BR /> ...<BR /> ods msoffice2k close;<BR /> [/pre]<BR /> <BR /> In that way, the HTML file that you create and open with Excel will have some bolding in the column headers (if I remember correctly) but there are no colors, otherwise.<BR /> <BR /> cynthia Wed, 24 Oct 2007 14:31:35 GMT Cynthia_sas 2007-10-24T14:31:35Z https://communities.sas.com/t5/SAS-Enterprise-Guide/exprting-excel-without-cell-color/m-p/5190#M1640 Hi am using the below mentioned code to export the output to an excel file. The cells are shaded with some colour.<BR /> <BR /> ods msoffice2k file= "/apps/sas/ReportsRepository/Reports/BSS/BMA/CSV/Monthly/myexcelfile.xls" ;<BR /> <BR /> proc report data=WORK.QUERY8283 nowd headskip split='*' spacing=1; <BR /> <BR /> How can I supress the cell background colouring Wed, 24 Oct 2007 14:19:49 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/exprting-excel-without-cell-color/m-p/5190#M1640 SanjayM 2007-10-24T14:19:49Z https://communities.sas.com/t5/SAS-Enterprise-Guide/exprting-excel-without-cell-color/m-p/5191#M1641 Hi:<BR /> Try using different style templates. STYLE=MINIMAL is a very plain style.<BR /> [pre]<BR /> ods msoffice2k file= "/myexcelfile.xls" style=MINIMAL;<BR /> ...<BR /> ods msoffice2k close;<BR /> [/pre]<BR /> <BR /> In that way, the HTML file that you create and open with Excel will have some bolding in the column headers (if I remember correctly) but there are no colors, otherwise.<BR /> <BR /> cynthia Wed, 24 Oct 2007 14:31:35 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/exprting-excel-without-cell-color/m-p/5191#M1641 Cynthia_sas 2007-10-24T14:31:35Z