Forum Discussion
Solver causes non-English functions to appear
Doug,
The problem still exists and it's not confined to a single computer or Excel installation. I have two separate computers each running Office 365 under separate (different) Microsoft accounts and both exhibit the same problem in Excel of non-English function names appearing in the functions list. It seems to be a bug in Solver.
Either nobody else apart from you has experienced this and/or nobody has an answer.
Cheers,
Geoff
The non-English UDF's are contained within the SOLVER.XLAM file, in the module VBA_Functions1. And example line from this module is provided below. I have been trying to solve the same problem you have, removing these many (83) non-English UDF's from the Insert Function window. SOLVER.XLAM has permissions issues (a read only file, with other security features) that make it hard to modify, but am sure someone smarter than I am can find a way. Btw, SOLVER.XLAM is password protected - the password is Wildebeest!!
Have fun!
TB
=============== example extract from VBA_Functions1 module within Solver.xlam=========
' French - 1036
'
Function SolveurAjouter(réf_Cellule As Variant, Relation As Integer, Optional formule As Variant) As Variant
SolveurAjouter = SolvAdd(réf_Cellule, Relation, formule)
End Function
- Hi Bremnert,
I only see the Dutch Solver functions (in addition to the English ones of course!) when I type an = sign. No other languages. Can you suggest a way to stop this. I am reasonably confident working with VBA and have looked into the Solver.xlam code...but as you no doubt know it's long and complex. Any thoughts on how to stop the Dutch functions from appearing?
Cheers,
Geoff Frost 
Thanks for the explanation. That's very helpful.
Microsoft should provide a method of removing non-English language functions if the user so desires. Why bloat the UDF list for no good reason!
Cheers,
Geoff Frost