Excel 2007 File > New set the workbook

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??
Fi69Asked:
Who is Participating?
 
Rory ArchibaldCommented:
You would have to override the builtin command using XML (see Ron's site here for instructions: http://www.rondebruin.nl/ribbon.htm).
Alternatively, use Ctrl+N or the New button on the Quick Access Toolbar instead and your template will be used.
0
 
Fi69Author Commented:
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!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.