Article ID: 162794
Article Last Modified on 10/22/2000
APPLIES TO
- Microsoft Excel 97 Standard Edition
This article was previously published under Q162794
SYMPTOMS
When you insert a worksheet in Microsoft Excel 97, the name of the
worksheet may be different from the name you expected.
For example, instead of sheet names that appear as follows
sheet names may appear as follows:
Sheet1 (2)
Sheet1 (3)
Sheet1 (4)
CAUSE
This problem occurs when you use a custom worksheet template (Sheet.xlt) in
the Xlstart folder.
WORKAROUND
To work around this problem, manually rename the worksheets. To rename a
worksheet, do the following:
- On the Format menu, point to Sheet, and then click Rename.
-or-
Double-click the sheet tab of the worksheet you want to rename.
- Type the new sheet name.
- Press ENTER.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products
listed at the beginning of this article.
MORE INFORMATION
A template in Microsoft Excel is a workbook that contains specific
formatting that you can used as a model for other workbooks. A template can
include standardized text, such as page headers and row and column labels,
Visual Basic for Applications macros, and custom toolbars.
REFERENCES
For more information about creating templates, click the Index tab in
Microsoft Excel Help, type the following text
and then double-click the selected text to go to the "Customize the
defaults for a workbook or worksheet by using a template" topic.
Additional query words: 97 XL97
Keywords: kbbug KB162794