Excel formula hyperlink not working in GERMAN locale

1
votes

I have a spreadsheet with a formula similar to the following: =HYPERLINK("https://example.com/issue?id=MS-212", "MS-212")

The hyperlink is displayed and works when used in with the default US locale. When the locale is changed to german, the formula fails with a "We found a problem with this formula. Try clicking Insert Function on the Formulas tab to fix it, or click Help for more info on common formula problems." message.

Any solutions to make this work with non-US locale?

1
excelhyperlinkformula
Shouldn't you be using a ; instead of a , for the DE-DE locale? e.g. =HYPERLINK("https://example.com/issue?id=MS-212"; "MS-212"). See HYPERLINK (Funktion). - user4039065
How did you change the locale? The , to ; conversion should happen by auto-magic when Excel opens the spreadsheet. - Robin Mackenzie
superuser.com/questions/668440/… - Robin Mackenzie

1 Answers

1
votes

The first comment answers the question. In a DE-DE locale, the formula should use a ';' separator instead of the ',' separator.

This requires understanding the target locale a requirement when generating a CSV for excel.