Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

You receive an error message when you use right bracket in text file name in Excel 2003 and earlier versions


View products that this article applies to.

This article was previously published under Q154876

↑ Back to the top


Symptoms

In the versions of Microsoft Excel that are listed in the "Applies To" section, 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.

↑ Back to the top


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.

↑ Back to the top


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 ([).

↑ Back to the top


More information

In Excel, the left and right bracket characters ([ and ]) have special meaning. In worksheet formulas, they are used to separate the workbook name from the names of sheets contained within the workbook. For example:
   =[Book1.xls]Sheet1!$A$1
				
If you open a file whose name contains either a left or a right bracket, Excel may mishandle the file's name.

Note A file whose name contains a left bracket character but not a right bracket character should not be affected by this problem.

↑ Back to the top


References

For more information about renaming sheet tabs, click the Index tab in Microsoft Excel Help, type the following text
renaming sheets
and then double-click the selected text to go to the "Rename a sheet" topic.

↑ Back to the top


Keywords: KB154876, kbexpertisebeginner

↑ Back to the top

Article Info
Article ID : 154876
Revision : 3
Created on : 1/6/2007
Published on : 1/6/2007
Exists online : False
Views : 43