Excel: Template Unexpectedly Opens in Edit ModeLast reviewed: July 16, 1997Article ID: Q89979 |
The information in this article applies to:
SYMPTOMSIn versions of Microsoft Excel earlier than 4.0 for Windows, when a worksheet, chart, or macro sheet containing links to a worksheet template is open, and you then open the worksheet template, the template file is opened in edit mode rather than as a template.
CAUSEThis problem occurs with worksheet templates only. In addition, it occurs regardless of whether you choose Open from the File menu, choose the filename from the most recently used file list on the File menu, or use the OPEN() macro function.
WORKAROUNDTo open the worksheet template as a template (not in edit mode), you must close files that are linked to it before you open the template.
STATUSThis problem has been corrected in Microsoft Excel version 5.0.
MORE INFORMATIONIn Microsoft Excel, worksheets, charts, and macro sheets can be saved as templates to be used when you want to create other documents that will have similar format and content. The original template file can be opened for editing by holding down the SHIFT key while selecting the filename in the File Open dialog. In Microsoft Excel for Windows, the file opens as FILENAME.XLT, and in Microsoft Excel for the Macintosh, it opens as FILENAME. When simply opening the template, it will open as FILENAMEn, where n is a number corresponding to the number of times the template has been opened in the current session of Microsoft Excel. If an open worksheet, chart, or macro sheet is linked to a worksheet template and this template is then opened, the template does not open as FILENAMEn as expected, it opens for editing as FILENAME.XLT (Windows) or FILENAME (Macintosh).
Steps to Reproduce Problem
Additional query words 3.00 4.00 4.00a |
================================================================================
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |