title: When using Excel's "Print Titles" how do i change the titles midway down the sheet
body: <p>I have a classic ASP web app that outputs reports to Excel, but it's really just html.</p>
  
  <p>Some reports output with multiple groups and each group can span multiple pages (vertically).  I'm aware of the "Page Titles" ability of Excel to print a specified row (or rows) on every page, however, I need the title of each group to also display in the title. Otherwise the title of the first group gets displayed as the title of every group.</p>
  
  <p>I saw on google groups that someone suggested putting each group on a separate worksheet however I don't think I can output multiple worksheets easily - or at all - using html alone.</p>
  
  <p>I'm looking for a quick and dirty solution as I don't have much time to devote to maintaining this crufty old app.</p>