Microsoft KB Archive/107545

= Multiple Sheets Inserted with Autotemplate =

Article ID: 107545

Article Last Modified on 8/15/2003

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition
 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q107545



SUMMARY
In Microsoft Excel, when you save a file as an autotemplate, all of the sheets in the file, not just the first sheet, are saved in the autotemplate. As a result, if you insert the autotemplate into an open workbook, more than one sheet may be inserted.

To work around this behavior, remove all sheets but one before you save the autotemplate.



Microsoft Excel 97 and Microsoft Excel 98 Macintosh Edition
In Microsoft Excel, you can create a special type of file called an autotemplate. Autotemplates are template files that you save in either of the following folders:


 * Program Files\Microsoft Office\Templates
 * Microsoft Office: Templates (on a Macintosh computer)

In addition, when you save autotemplates, click Save As on the File menu, click Template in the Save As Type list, and use the names that are listed in the following table.

                       Save file in   Sheet type           templates folder as   -

Worksheet           Worksheet Chart               Chart Dialog              MS Excel 5.0 Dialog MS Excel 4.0 Macro  MS Excel 4.0 Macro

To insert an autotemplate sheet into your workbook, right-click any sheet tab in your workbook, and then click Insert on the shortcut menu. Then, double-click the appropriate desired autotemplate in the Insert dialog box.

NOTE: If you click Worksheet on the Insert menu, you will not have the worksheet template mentioned above inserted into your workbook; a generic default worksheet will be inserted into your workbook. If you save a workbook, with a single worksheet, as a template file called "Sheet" in the Program Files\Microsoft Office\Office\Xlstart folder, this template worksheet will be inserted into your workbook when you click Worksheet on the Insert menu.

Microsoft Excel Versions 5.0 and 7.0
In Microsoft Excel, you can create a special type of file called an autotemplate. Autotemplates are template files that you save in the Excel\Xlstart directory with the names that are listed in the following table.

                       Save file in startup Sheet type          directory as   -

Worksheet           Sheet.xlt Chart               Chart.xlt Module              Module.xlt Dialog              Dialog.xlt MS Excel 4.0 Macro  Macro.xlt

Microsoft Excel for the Macintosh, version 5.0
In Microsoft Excel for the Macintosh, the files are saved in the 'System Folder:Preferences:Excel Startup Folder (5)' folder with the names that are listed in the following table.

                       Save file in startup Sheet type          directory as   -

Worksheet           Worksheet Chart               Chart MS Excel 4.0 Macro  Macro Module              Module Dialog              Dialog

For more information on replacing the default module with an autotemplate, query on the following words in the Microsoft Knowledge Base:

  replace and default and module and autotemplate

To save a file as an autotemplate, follow these steps:


 * 1) On the File menu, click Save As.
 * 2) In the Save As dialog box, under Save File As Type, select Template.
 * 3) In the Directories list box, switch to the appropriate folder or directory, as described above.
 * 4) Type the appropriate file name from the list above into the File Name box.
 * 5) Click OK to save the autotemplate.
 * 6) On the File menu, click Close to close the autotemplate file.

When you create an autotemplate, the autotemplate is used in place of the default sheet when you insert a sheet into a workbook. This allows you to create custom default settings for all of the sheets that you use.

