Right bracket in text file name causes problems (154876)
The information in this article applies to:
- Microsoft Office Excel 2003
- Microsoft Excel 2002
- Microsoft Excel 2000
- Microsoft Excel 97 for Windows
- Microsoft Excel 98 Macintosh Edition
This article was previously published under Q154876 SYMPTOMS
In the versions of Microsoft Excel listed above, you may receive the
following error message when you try to rename a sheet tab:
While renaming a sheet, you entered an invalid sheet name. The
following are possible reasons for this:
The error message then goes on to explain potential reasons why the error
is occurring.
CAUSE
This error message occurs if you open a text file whose name contains a
right bracket character (]) and then try to rename the file's sheet tab.
RESOLUTION
To avoid this problem, make sure your text file name does not contain a
right bracket character (]) before you open the file in Microsoft Excel.
Preferably, the file name should also not contain a left bracket character
([).
REFERENCES
For more information about renaming sheet tabs, click the Index tab in
Microsoft Excel Help, type the following text
and then double-click the selected text to go to the "Rename a sheet"
topic.
Modification Type: | Major | Last Reviewed: | 5/5/2005 |
---|
Keywords: | KB154876 |
---|
|