Interesting. When I look at the site for MSOFFICE2K_X (drilling to pagebreak topic from the above site), this is what I see: http://support.sas.com/rnd/base/ods/odsmarkup/msoffice2k/index.html#pagebreaks ods tagsets.msoffice2k_x path="c:\temp\trash\test" file="pagebreak.xls" options(embedded_titles="no"        pagebreak_row="20,30,40,90"); proc print data=sashelp.orsales; run; ods tagsets.msoffice2k_x close; When I try a suboption of PAGEBREAKS, with MSOFFICE2K_X, I get the "unrecognized" warning:   45 ods tagsets.msoffice2k_x path="c:\temp\" 46 file="pb_wrong.xls" 47 options(pagebreaks='yes'); NOTE: Writing TAGSETS.MSOFFICE2K_X Body file: pb_wrong.xls v2.1 Unrecognized option: PAGEBREAKS 48 49 proc print data=sashelp.class; 50 run; NOTE: There were 19 observations read from the data set SASHELP.CLASS. NOTE: PROCEDURE PRINT used (Total process time): real time 0.10 seconds cpu time 0.01 seconds 　 51 52 53 ods tagsets.msoffice2k_x close The only option coded in the example on the web site is PAGEBREAK_ROW as shown above; although, when I do a doc='Help' suboption, these are the two pagebreak related suboptions for MSOFFICE2K_X: NOTE: Writing TAGSETS.MSOFFICE2K_X Body file: pagebreak.xls v2.1 ============================================================================== Short descriptions of the supported options ============================================================================== Name    :  Description ... more suboptions ... PAGEBREAK :       Provides the ability to modify pagebreak PAGEBREAK_ROW :       Sets the rows break on However, I do note that TAGSETS.EXCELXP does have a PAGEBREAKS suboption -- the suboptions are not interchangeable between tagsets, at least in my versions. NOTE: Writing TAGSETS.EXCELXP Body file: c:\temp\xp_opt.xls ============================================================================= ============================================================================== Long descriptions of the supported options ... more suboptions .... PageBreaks:   Default Value 'No'      Values: yes, no, on, off.      If set to 'yes' page breaks will be inserted into the stylesheet.  The      pagebreak style element will be used to define what that pagebreak looks      like.  A sample style definition looks like this.                  style pagebreak /                      cellheight=8                      foreground=black                      tagattr="HorzStripe";      It is not necessary to have a style element.  In it's absence a blank row      will be inserted. ============================================================================== NOTE: This is the Excel XP tagset (Compatible with SAS 9.1.3 and above, v1.94, 09/09/12). Add options(doc='help') to the ods statement for more information. The bottom line is that I recommend using doc='Help' in your first run of any TAGSET destination after you update it to be sure that you understand the correct suboptions that can be specified for each destination. cynthia ... View more