On the Display tab of the summary Key field dialog, the last option is to "Insert page break when printing".
I was able to set that option, export to Excel 2007 (.xlsx) and the page break took effect when I viewed the print preview.
Under the Options -> Export and Clipboard settings, I also have the apply formatting to Excel files option enabled.
Try that. Any better?
Thanks for the suggestion, but I already had that checked & it still moves the subtotal for the key value to the top of the next page. My Display tab shows:
Insert subtotal line checked
Insert one blank line before subtotal
Include key value in subtotal value is checked
Insert one blane line after each key value change
Insert page break when printing is checked
Also I have apply formatting to Excel files checked in the options.
I have tried various versions of the above, but nothing has worked. This is a model that I have had for several years and versions of Monarch.