<div>
Thanks Rorya, I've done what you've suggested as a solution. I had noticed the the quick access button and Ctrl+N shortcut generated the correct workbook. It amazes me that the File &gt;&nbsp;New &gt;&nbsp;workbook doesn't target the same workbook. Seems crazy to me!
</div>


Thanks Rorya, I've done what you've suggested as a solution. I had noticed the the quick access button and Ctrl+N shortcut generated the correct workbook. It amazes me that the File > New > workbook doesn't target the same workbook. Seems crazy to me!

<div>
<div class="content wysiwyg-content">
Hi experts.<br />
<br />
I want to set the default book that opens with I click Office Button &gt;&nbsp;New in Excel 2007. &nbsp;I have placed my book.xltx file in the XLSTART startup location of:<br />
<br />
C:\Users\&lt;username&gt;\AppDat<wbr />a\Roaming\<wbr />Microsoft\<wbr />Excel\XLST<wbr />ART<br />
<br />
This works well and comes into affect when I OPEN the application - my workbook opens as the default workbook.<br />
<br />
However, I want this workbook to open when I click Office Button &gt;&nbsp;New. I've tried putting it in <br />
C:\Users\&lt;username&gt;\AppDat<wbr />a\Roaming\<wbr />Microsoft\<wbr />Templates<br />
no luck<br />
<br />
I've tried naming it Sheet and putting it in<br />
C:\Users\&lt;username&gt;\AppDat<wbr />a\Roaming\<wbr />Microsoft\<wbr />Templates<br />
but no luck.<br />
<br />
Help??<br />

</div>
</div>


Hi experts.

I want to set the default book that opens with I click Office Button > New in Excel 2007.  I have placed my book.xltx file in the XLSTART startup location of:

C:\Users\<username>\AppData\Roaming\Microsoft\Excel\XLSTART

This works well and comes into affect when I OPEN the application - my workbook opens as the default workbook.

However, I want this workbook to open when I click Office Button > New. I've tried putting it in 
C:\Users\<username>\AppData\Roaming\Microsoft\Templates
no luck

I've tried naming it Sheet and putting it in
C:\Users\<username>\AppData\Roaming\Microsoft\Templates
but no luck.

Help??


Excel 2007 File &gt; New set the workbook

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Excel 2007 File &gt; New set the workbook

Excel 2007 File > New set the workbook