Nov 02 2020 06:28 AM
Nov 02 2020 06:28 AM
Hello, is there someone who could tell me why in Excel formula list I have my UDF mixed with the foreign version of Excel built in functions. As you can see excel is in French but my own UDF are mixed with Italian version of excel functions, I don't use Italian, further in the list there is norwegian version of excel functions, It is a mess to find out my own UDF.
Nov 02 2020 07:00 AM
Change language in Excel
Follow the step-by-step instruction.
Note: These instructions apply to Microsoft Office Excel, version 2010 or later on Windows.
Open Excel and then switch to the "File" tab.
Go to "Options" at the bottom left.
Then a new window will open. Click on "Language" in the ribbon on the left. In the "Select editing language" area you will see "e.g. German (Germany)" marked with "<standard setting>". Click on your preferred language and then on the button "Set as default".
Note: You can expand the range of languages using the "Add additional editing languages" drop-down menu. Make your selections, then click Add.
In the lower area ("Select display language") you can also change the display and help language. Simply click on the language and then on "OK".
Then restart Excel once.
Hope I was able to help you.
Thank you for your understanding and patience
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here
Nov 02 2020 07:32 AM
@NikolinoDEThank you but it doesn't fix the problem, I have found a solution with unselect the Excel solver add on. What I have taken for foreign version of excel functions were the foreign version of Excel functions bound with the Excel solver. I ll try to manage it according what I need at the moment switching from select to unselect and vice versa solver add on.
Nov 02 2020 07:53 AM
Jul 25 2021 07:49 AM
Discovering recently all kinds of UDF's in foreign languages in my function list got me really worried. Googled for hours trying to find a way to disable or remove them without success. Unselecting the Solver Addin made all of them disappear. Thanks a lot! Never would have thought that this could be the cause.