Can't Add References If Filenames Similar (116189)
The information in this article applies to:
- Microsoft Excel for Windows 95
- Microsoft Excel for Windows 5.0
- Microsoft Excel for Windows NT 5.0
This article was previously published under Q116189 SYMPTOMS
In Microsoft Excel for Windows, you may be unable to add references to
two different files when the names of the files are identical except for
the presence of accent marks on certain characters in the filenames.
CAUSE
This problem occurs because the Visual Basic Programming System,
Applications Edition, is sometimes "accent-insensitive." When filenames
contain accented characters, such as "e" (acute accent), "e" (circumflex
accent), or "i" (grave accent), the characters may be "remapped" to a non-
accented character, such as plain "e" or "i."
WORKAROUND
To prevent this error from occurring, make sure your filenames differ
by more than accents before you attempt to add references to them.
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 as it becomes available.
Modification Type: | Minor | Last Reviewed: | 8/15/2005 |
---|
Keywords: | KB116189 |
---|
|