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)
How do I restore the original settings for workbooks and new sheets?
-
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
- 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
- In Microsoft Windows Explorer, remove any template files from the XLStart folder. The XLStart folder is usually located at:
A built-in template is missing in my version of Microsoft Excel.
The built-in template may have been deleted. You can re-install it.
If you originally installed your Microsoft Office program from a network file server or from a shared folder, you must install or remove components from that location. If you installed your Office program from a CD-ROM and you've mapped your CD-ROM drive to a new drive letter since installing the Office program, reinstall from the CD-ROM. If you're running any Office program files from the CD-ROM, you must uninstall the Office program and then reinstall it from the CD-ROM.
-
Quit all programs.
- On the Start menu, click Control Panel.
- Double-click the Add/Remove Programs icon.
-
Do one of the following:
If you installed your Office program as part of Microsoft Office, click Microsoft Office in the Currently installed programs box, and click the Change button.
If you installed your Office program individually, click the name of your program in the Currently installed programs box, and click the Change button.
- If you are using Microsoft Windows Server 2003, select Add or Remove Features.
- In the Microsoft Office 2003 Setup Wizard, select Microsoft Office Excel if you are using Windows Server 2003; otherwise, select Microsoft Excel. Select Choose advanced customization of applications. Click Next.
- Double-click Microsoft Excel for Windows.
- Select Spreadsheet Templates. Click Update.
I saved a file with the .xlt extension, but I can't use it as a template.
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 (Book.xlt) and the default sheet template (Sheet.xlt) in the XLStart folder or the alternate startup folder. 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
A workbook doesn't use the calculation mode saved in the template it was based on.
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.