Do you have an example of the code you're using or can you duplicate the behavior by using SASHELP.CLASS???? If your labels are too long, they might wrap over to a second row. I am just having a hard time visualizing what you mean by "the column labels take up rows 1-n" depending on the how the headings are split.
When I use the program below, all my column headings are ONLY in Row 1.
Thanks Cynthia. Found my problem. The _odsdest assignment was inside a macro, hence not global, hence not available to %stpbegin, hence HTML destination and not tagsets.excelXP as I assumed it was. Mea culpa. ;-(