Microsoft KB Archive/95196

= Microsoft Knowledge Base =

Excel Err Msg: 'Name Cannot Be the Same As Built In Name'
Last reviewed: September 12, 1996

Article ID: Q95196

The information in this article applies to:


 * Microsoft Excel for Windows, versions 3.0, 4.0, 4.0a, 5.0
 * Microsoft Excel for the Macintosh, versions 3.0, 4.0, 5.0

SUMMARY
When you open a Microsoft Excel file in a language version of Microsoft Excel that is different from the one in which the file was created, you may receive the following error message:

Name cannot be the same as built in name

MORE INFORMATION
This error message occurs because of the way built-in names are translated from one language to another. When a worksheet is opened in a different language version of Microsoft Excel, if a built-in defined name is translated to a name that already exists on the worksheet, there would be two instances of the same name on that worksheet. Since it is not possible to have two instances of the same defined name in Microsoft Excel, the error message is displayed and you are prompted to enter a new name for the second defined name. The built-in name is then translated correctly.

For example, if you use the German version of Microsoft Excel and you define an area on your worksheet as a database, the defined name &quot;datenbank&quot; is created. If you then create a defined name &quot;database&quot; and later open the file in an English-language version of Microsoft Excel, the program will attempt to translate the German name &quot;datenbank&quot; into &quot;database&quot;. Since that name already exists, Microsoft Excel will display the error message and a dialog box prompting you to change the name &quot;database&quot; to a different name. If you enter a new name, &quot;datenbank&quot; will be successfully translated into &quot;database&quot;.

There are six built-in names in Microsoft Excel. In English, these names are &quot;database,&quot; &quot;criteria,&quot; &quot;data_form,&quot; &quot;extract,&quot; &quot;print_titles,&quot; and &quot;print_area.&quot;

The headings below are the English built-in names with a list of their foreign equivalents:

Database
German                 Datenbank Dutch                  Database French/French Canadian Base_de_donnees (1)

Italian                Database Norwegian              Database Portuguese             Banco_de_dados Spanish                Base_de_datos Swedish                Databas

Criteria
German                 Suchkriterien Dutch                  Criteria French/French Canadian Criteres (2)

Italian                Criteri Norwegian              Vilkar (3) Portuguese             Criterios (4) Spanish                Criterios Swedish                Villkor

Data_Form
German                 Datenmaske Dutch                  Dataformulier French/French Canadian Grille

Italian                Modulo_dati Norwegian              Dataskjema Portuguese             Formulario_de_dados (5) Spanish                Ficha_de_datos Swedish                Dataformular (6)

Extract
German                 Zielbereich Dutch                  Ophalen French/Canadian French Extraction

Italian                Estrai Norwegian              Velg_ut Portuguese             Area_de_extracao (7, 8, 9) Spanish                Area_de_extraccion (10) Swedish                Urval

Print_Titles
German                 Drucktitel Dutch                  Afdruktitels French/Canadian French Impression_des_titres

Italian                Titoli_stampa Norwegian              Utskriftstitler Portuguese             T tulos_de_impressao (11) Spanish                Titulos_a_imprimir Swedish                Utskriftsrubriker

Print_Area
German                 Druckbereich Dutch                  Afdrukbereik French/Canadian French Zone_d_impression

Italian                Area_stampa Norwegian              Utskriftsomrade (12) Portuguese             Area_de_impressao (13, 14) Spanish                Area_de_impresion (15) Swedish                Utskriftsomrade (16) Notes: (1) The second &quot;e&quot; in donnees contains an acute accent. (2) The first &quot;e&quot; in Criteres contains a grave accent. (3) The &quot;a&quot; in Vilkar has a small circle over it. (4) The &quot;e&quot; in Criterios contains an acute accent. (5) The &quot;a&quot; in Formulario contains an acute accent. (6) The third &quot;a&quot; in Dataformular contains a dieresis (7) The first &quot;a&quot; in Area contains an acute accent. (8) The &quot;c&quot; in extracao contains a cedilla. (9) The second &quot;a&quot; in extracao contains a tilde. (10) The &quot;o&quot; in extraccion contains an acute accent. (11) The &quot;a&quot; in impressao contains a tilde. (12) The &quot;a&quot; in Utskriftsomrade has a ring over it. (13) The first &quot;a&quot; in Area contains an acute accent. (14) The &quot;a&quot; in impressao contains a tilde. (15) The &quot;o&quot; in impresion contains an acute accent. (16) The &quot;a&quot; in Utskriftsomrade has a ring over it.