Hi: You are correct -- ODS MSOFFICE2K does not support multiple sheets, but you can use ODS MSOFFICE2K_X to get multiple sheets -- and the up side is that you can also do graphs with these type of HTML files that Excel can open. Do not assume that TAGSETS.EXCELXP suboptions will also work for ODS MSOFFICE2K -- they could have different suboptions and most likely do, because TAGSETS.EXCELXP produces an XML file and MSOFFICE2K produces an HTML file. You can ALWAYS find out what suboptions work with a destination by: ods msoffice2k file='I:\anuj\temp folder\show_line_mso2k.xls' style=analysis options(doc='Help'); and compare it to ods tagsets.msoffice2k_x file='I:\anuj\temp folder\show_line_mso2kx.xls' style=analysis options(doc='Help'); and compare it to ods tagsets.excelxp file='I:\anuj\temp folder\show_line_xp.xml' style=analysis options(doc='Help'); I am pretty sure you will find that autofit_height is an Excelxp suboption that may not be available in the other destinations. I found for example, when I ran my code, that the height did autoadjust for me in the resulting file. Did you run my code and see the results? cynthia
... View more
