XL7: Filename from Template Not Named Correctly

Last reviewed: March 27, 1997
Article ID: Q134828
7.00 WINDOWS kbusage

The information in this article applies to:

  • Microsoft Excel for Windows 95, version 7.0

SYMPTOMS

When you open a new file from a template, the assigned filename of the new file may not result in a filename that is incremented one greater than the last file opened from that template.

For example, the first workbook opened from "Testfile.xlt" is assigned the name "Testfile1." If "Testfile1" is then closed and a second workbook is opened from the "Testfile" template, it too is assigned the name "Testfile1."

RESOLUTION

Where sequential filenames are required, use any of the following methods.

Method 1: Do not close files created from a template until all files to be

          created from that template are opened.

Method 2: Use the Save As command on the File menu to rename the files to
          their correct numbers.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

In earlier versions of Microsoft Excel and in other Microsoft Office for Windows 95 applications, when you open a new file from a template, the name assigned to the new file is the name of the template followed by a number. That number starts at 1 for the first file opened from a particular template ("testfile1" for example) and is incremented by one for all subsequent files opened from that template ("testfile2","testfile3") for as long as that application is open. In Microsoft Excel for Windows 95, the number assigned to a new file opened from a template is the lowest number not currently in use for that particular file/template name.


KBCategory: kbusage
KBSubcategory:

Additional reference words: 7.00 incorrect wrong
Keywords : kbusage
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.