up vote 0 down vote favorite
share [g+] share [fb]

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.

link|improve this question
58% accept rate
feedback

1 Answer

up vote 1 down vote

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.

link|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
feedback

Your Answer

 
or
required, but never shown
discard

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