I have an application that reads data from spreadsheets based upon named
ranges. I have a customer that has ported the application over to French
Windows and French Excel XP. The application now gets an error reading one
of the named ranges, specifically L1SAVE. I now have an installation with
French Windows and French Excel XP and have been working in that environment
to try to figure out why the name will not work. When I go directly into
Excel and select the L1SAVE name range I get an error message indicating that
the name is invalid. I can try to create a new named range with that name
and it gives me the same error. I tried varying the name but if I give it a
name that begins with L(upper or lower case) with a number other than zero
following, I get the error message about it being an invalid name. Is there
some special significance to the combination of L and a non-zero number in
the French version of Excel (maybe related to currency francs?). If so how
would I turn off the option that is not allowing these names?