Excel 2007 File > New set the workbook

Posted on 2011-10-10
Last Modified: 2012-05-12
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:


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
no luck

I've tried naming it Sheet and putting it in
but no luck.

Question by:Fi69
    LVL 85

    Accepted Solution

    You would have to override the builtin command using XML (see Ron's site here for instructions:
    Alternatively, use Ctrl+N or the New button on the Quick Access Toolbar instead and your template will be used.

    Author Closing Comment

    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!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
    How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
    This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
    This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now