XL7: Template in New Dialog Box Displayed Without Extension

Last reviewed: March 27, 1997
Article ID: Q131393
7.00 WINDOWS kbother

The information in this article applies to:

  • Microsoft Excel for Windows 95, version 7.0

SYMPTOMS

In Microsoft Excel, when you open the New dialog box to create a new file based on a template, a template on the General tab may be displayed without the .XLT file extension, even when you have MS-DOS file extensions displayed in Windows.

CAUSE

This behavior occurs if you save a template file to the XLSTART folder in the Microsoft Excel folder instead of to the TEMPLATES folder in the Microsoft Office folder. The Microsoft Excel XLSTART folder is available for compatibility with Microsoft Excel version 5.0. In Microsoft Excel version 7.0, you can still create a new workbook from a template stored in this folder. However, when you view the template file in the New dialog box, the filename is displayed without the .XLT file extension.

When you save a file as a Template in Microsoft Excel, the default file location is the Microsoft Office TEMPLATE folder. Templates contained in this folder are displayed with the .XLT file extension in the New dialog box when you have MS-DOS file extensions displayed in Windows.

RESOLUTION

To work around this behavior, save all new templates that you create in Microsoft Excel version 7.0 to the Microsoft Office TEMPLATE folder or the SPREADSHEET SOLUTIONS folder in the TEMPLATE folder.

Note that this behavior does not affect the functionality of the templates.

REFERENCES

For more information about where to store templates in Microsoft Excel, click the Index tab in Microsoft Excel Help, type the following text

   templates, f

double-click the selected text, and then double-click "Where To Store Templates" to go to the "Where To Store Templates" topic.


KBCategory: kbother
KBSubcategory: xlwin

Additional reference words: 7.00
Keywords : xlwin kbother
Version : 7.00
Platform : WINDOWS


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: March 27, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.