Microsoft Excel lists a template in the Templates dialog box only if you save the template file in one of the following locations:

• The Templates folder or a subfolder in the Templates folder, which is usually

  C:\Documents and Settings\<user_name>\Application Data\Microsoft\Templates

• The XLStart folder, which is usually

  C:\Program Files\Microsoft Office\Office11\XLStart

• The location you specified in the At startup, open all files in box on the General tab in the Options dialog box (Tools menu)

1. If you want to keep your Book.xlt or Sheet.xlt files, rename them and save them in the Templates folder, usually located at:

   C:\Documents and Settings\<user_name>\Application Data\Microsoft\Templates

2. Do one or more of the following:
   • In Microsoft Windows Explorer, remove any template files from the XLStart folder. The XLStart folder is usually located at:

     C:\Program Files\Microsoft Office\Office11\XLStart

   • If the files aren't in the XLStart folder, look in the folder specified in the At startup, open all files in box on the General tab in the Options dialog box (Tools menu).
   • To restore original settings for workbooks, remove Book.xlt. To restore original settings for worksheets, remove Sheet.xlt

The built-in template may have been deleted. You can re-install it.

Excel does not save a file in template format if you type the .xlt file extension in a file name. To save a file as a template, click Save As on the File menu. In the Save as type box, click Template. In the Save in list, locate and click the location where you want to save the template. In the File name box, enter a file name, and then click Save.

Save custom templates in the Templates folder. If you save the file to a different location, you can only open the file, not use it as a template. Save the default workbook template (default workbook template: The Book.xlt template that you create to change the default format of new workbooks. Excel uses the template to create a blank workbook when you start Excel or create a new workbook without specifying a template.) (Book.xlt) and the default sheet template (default worksheet template: The Sheet.xlt template that you create to change the default format of new worksheets. Excel uses the template to create a blank worksheet when you add a new worksheet to a workbook.) (Sheet.xlt) in the XLStart folder or the alternate startup folder (alternate startup folder: A folder in addition to the XLStart folder that contains workbooks or other files that you want to be opened automatically when you start Excel and templates that you want to be available when you create new workbooks.). The Templates folder is usually

C:\Documents and Settings\<user_name>\Application Data\Microsoft\Templates

and the XLStart folder is usually

C:\Program Files\Microsoft Office\Office11\XLStart

Excel uses the same calculation mode for all open workbooks. If you change the calculation mode in one open workbook, the mode is changed for all open workbooks.