Bug in DoCmd.TransferSpreadsheet acExport?
<p>Steps to reproduce:</p>

<ol>
<li>Open a blank workbook in Excel</li>
<li>Page Layout tab --> [Print Titles] button --> Rows to repeat at top: <code>$1:$1</code></li>
<li>Save (in .xlsx format) and close workbook</li>
<li>Open MS Access</li>
<li>Export any table or query to the workbook we just saved: </li>
</ol>

<p><code>DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xml, "TempQry", "C:\Book1.xlsx"</code></p>

<ol start="6">
<li>Open Book1.xlsx and click on Print Preview for Sheet1</li>
<li>Print preview shows the following error message: <strong>"Print preview is not available."</strong></li>
<li>Click on Page Setup then switch to Sheet tab: <strong>Rows to repeat at top:</strong> is blank</li>
</ol>

<p>Why is Print Preview unavailable and why is the "Rows to repeat at top" box blank?</p>