Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I wanted to use a customized excel template for all new files. Shure i can create a new template in the templates folder and in excel use new and select my template or double click on the template file.

But i wanted to use that template also when i'm creating a new file from the explorer context menu with mouse right click -> create new. It takes always the built-in(?) template.

share|improve this question
add comment

1 Answer

Save your template in the XLStart folder with the name book.xltx (as a template, extension depending on your version of excel).

XLStart folder can be found here:

Excel 2000 - C:\Program Files\Microsoft Office\Office\XLStart\

Excel XP - C:\Program Files\Microsoft Office\Office 10\XLStart\

Excel 2003 - C:\Program Files\Microsoft Office\Office 11\XLStart\

*Excel 2007 - C:\Program Files\Microsoft Office\Office 12\XLStart*

Next time you open a new excel document, it will use this template.

share|improve this answer
    
I know this, but it does not work as expected. No clue. –  PeterMmm Feb 15 '11 at 14:48
    
Ok, for the right click menu, it might be linked to a different template in the registry. Try to follow the answer in this link . I assume for you, under the .xlsx filetype, there is already a filename. Change that to your template name and try again. –  Yohsoog Feb 15 '11 at 15:08
    
@PeterMmm can you inform us if this worked this way? –  Yohsoog Feb 22 '11 at 0:07
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.