XL: Multiple Sheets Inserted with Autotemplate

• Microsoft Excel for Windows, versions 5.0, 5.0c
• Microsoft Excel for the Macintosh, versions 5.0, 5.0a
• Microsoft Excel for Windows NT, version 5.0
• Microsoft Excel for Windows 95, versions 7.0, 7.0a
• Microsoft Excel 97 for Windows
• Microsoft Excel 98 Macintosh Edition

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.

MORE INFORMATION

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)

                        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

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

                        Save file in startup
   Sheet type           directory as
   -----------------------------------------

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

   replace and default and module and autotemplate

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.

REFERENCES

"User's Guide," version 5.0, pages 657-658