Reserved names in Excel

Let say I select cell A1 and type in name box "RS" without quotes ja then press enter it accept name to range in Excel 2010 English version. But if I do same in Finnish langue version it don`t accept?
Is there any way to get reserved names in Excel in different language versions?

I known basic rules for those but why not accept RS but accept RT as well RU?

Originally Posted by lecxe

Hi

If you have the English version of excel you cannot us RS because it's the address of the current cell in R1C1 notation. RS comes from R(ow)C(olumn). In German you cannot use ZS from Z(eile)S(palte). I don't know finnish and I don't have the time now to look it up, but check if RS in Finnish is not from R(first letter of word row in Finnish)S(first letter of word column in Finnish).

Yes you are right
Finnish language R=Rivi ans S=Sarake so thats why RS is illegal name

Thanks
Kunde

Originally Posted by lecxe

Hi
There are a few other reserved names, like the ones that the Advanced Filter creates ("Criteria", "Extract", "_FilterDatabase") and some others.
I remember seeing a list with such names but I cannot remember where (or when). I remember it was a short list, though.

If it's of any use, here's the list I've got regarding use of Named Ranges, cobbled together from various posts on various sites:

- Must start with a letter, backslash or underscore
- Can only include letters, numbers, full stops (.) or underscores (i.e. cannot include spaces)
- Are case-agnostic (ENGINE = Engine = engine)
- Cannot be more than 255 characters
- Cannot be a cell reference (including 'RC') (watch out for new limitations caused by more rows/columns in 2007+ (up to row 1048576 not 65536, and column XFD not IV) so (e.g.) JC1979 is now a cell reference...)
- Cannot be just R,r,C or c (typing this in name area selects the current row or column)
(n.b. the last two wrt R/C are language-specific)

- Cannot be named as:

Consolidate_Area
Auto_Open
Auto_Close
Extract
Database
Criteria
Print_Area
Print_Titles
Recorder
Data_Form
Auto_Activate
Auto_Deactivate
Sheet_Title
_FilterDatabase

I would guess that the above words in different languages would be reserved in those languages, but I've never checked.

Regards,
Aardigspook

If your problem is solved, please go to 'Thread Tools' on your first post and 'Mark Thread as Solved'.
You don't need to give me rep if I helped, but thanks are appreciated.

Thank you for sharing.