felix, I get an "Invalid Expression" error. Do you know what is going on? Thanks
The values of the previous post are valid if you use Excel. If you made the changes directly on OpenOffice the correct values are:
"Zone_traduction" assigned to $Traduction.$A$1:$E$80 and "Local_language" assigned to ...

Pity it doesn't work with OpenOffice, but that's life.
Changing the values of two names in Insert->Names->Define makes it work properly with OpenOffice.
"Zone_Traduction" as =Traduction!$A$1:$E$80 and "Local_Language" as ='liste armée'!$E$3. This changes don't have any effect if you use Excel.