S skillmaster Apr 28, 2008 #1 i am trying to get a template i have created to be the default document every time excel is opened. how is it done!
i am trying to get a template i have created to be the default document every time excel is opened. how is it done!
D Dave Peterson Apr 28, 2008 #2 Just to add to edvwvw's reply... You can create a template workbook named book.xlt and store it in your XLStart folder. Excel will use that for new workbooks when you start excel and when you click on the New Icon on the Standard toolbar (xl2003 or lower). If you're using xl2007, you can add that New icon to the QAT so that you can use that template file.
Just to add to edvwvw's reply... You can create a template workbook named book.xlt and store it in your XLStart folder. Excel will use that for new workbooks when you start excel and when you click on the New Icon on the Standard toolbar (xl2003 or lower). If you're using xl2007, you can add that New icon to the QAT so that you can use that template file.
G Gord Dibben Apr 28, 2008 #3 To add to Dave's reply......stacking up here<g> Don't use the File>New...Blank Workbook or you will get the Excel default workbook. Use File>New or CTRL + n or New File Icon as Dave suggests. Gord Dibben MS Excel MVP
To add to Dave's reply......stacking up here<g> Don't use the File>New...Blank Workbook or you will get the Excel default workbook. Use File>New or CTRL + n or New File Icon as Dave suggests. Gord Dibben MS Excel MVP
