XL2000: Workbook Name Contains Invalid Characters

Article translations Article translations
Article ID: 215205 - View products that this article applies to.
This article was previously published under Q215205
This article has been archived. It is offered "as is" and will no longer be updated.
Expand all | Collapse all

Symptoms

In Microsoft Excel, you may see any of the following behaviors:
  • The name of the workbook may contain either of the bracket characters: [ ]

    -or-

  • The name on the sheet tab for the workbook contains the file name extension and a ] character preceding the sheet names, for example, .xls]Sheet1

    -or-

  • When you rename a sheet that contains the file name extension and ] character, you receive the following error message:
    While renaming a sheet or chart, you entered an invalid name. Try one of 
    the following:
    
     - Make sure the name you entered does not exceed 31 characters.
     - Make sure the name does not contain any of the following characters: 
       : \ / ? * [ or ]
     - Make sure you did not leave the name blank.
    						

Cause

These behaviors may occur when you do either of the following:
  • You programmatically save a file with a file name that includes the [ or ] characters.

    -or-
  • You open a file that was renamed outside of Excel, with a file name that includes the [ or ] characters.

Workaround

To work around this problem, save the file using a new name without [ or ] characters.

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

More information

When you programmatically save a file, Excel does not validate the file name by checking for either the [ or ] characters. Therefore, Visual Basic for Applications allows you to save a file with either or both of these characters.

Properties

Article ID: 215205 - Last Review: October 25, 2013 - Revision: 4.0
Applies to
  • Microsoft Excel 2000 Standard Edition
Keywords: 
kbnosurvey kbarchive kbbug kbnofix KB215205

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com