For example, if you saved the file as Ganchrow.xlt, then by clicking ”New” on the ”File” menu, you’d be able to select the template ”Ganchrow” and have all the above functions available.Īrray function. If you want these functions to only be available only by request then save the file under a different name in the XLStart directory. Alternatively, if you know what you’re doing, you could manually add the Excel VBA functions or module to your preexisting Book.xlt file.
If the file already exists you shouldn’t overwrite it unless you know the preexisting file to be empty but instead choose a different name as in the next paragraph. If you want these functions to be available every time you start Excel you’ll need to save the Book.xlt template file in your Excel XLStart directory (”C:\Program Files\Microsoft Office\OFFICE11\XLSTART\” by default for Excel 2003 - \Office12\XLSTART\ for Excel2007, \Office10\XLSTART\ for Excel 2002, and \Office\XLSTART\ for Excel 2000 and 97). The full list of Excel functions are listed below.
