Hi:
ODS TAGSETS.EXCELXP is actually creating an XML file -- Spreadsheet Markup Language XML from the Office 2003 standard. When you name the file as .XLS, you are just "fooling" the Windows Registry into launching Excel to open the XML instead of launching a browser or some other XML application. When you use ODS EXCEL, you are moving into the Office 2007 world, where Excel, Word and PPT all got new file extensions: XLSX, DOCX and PPTX. These NEW extensions are NOT the same as the 2003 XML and they are not binary XLS files. So it would be wrong and inappropriate to name an ODS EXCEL file with the .XLS extension. It MUST be given a .XLSX file extension. If you use .XLS, then Excel is not happy. However, if you try this: ods excel file='c:\temp\class.xlsx' style=htmlblue; proc print data=sashelp.class; run; ods excel close; Then it SHOULD work. If this works and your code does NOT work, using ODS EXCEL and the .XLSX extension, then you have an issue for Tech Support. cynthia
... View more