Support for German Locale in Named Range Formulae
English formulae are written into named region. This Excel file can be opened in an environment where the system is configured to German Locale however the English formula shall be translated to the German language. Following example demonstrates this feature, however, it requires Excel to be installed in German language and system locale shall be set to German as well.
Sample file for testing this feature can be downloaded from the following link: