Forum Discussion
Formula language problem
Language and locale are different settings. With French language in user interface you may have German locale.
I never checked, my guess Excel functions are in accordnce to the locale, not language.
I don't have german on my locale. I'm working with Office Online. I've checked my chrome settings, and french is also my default language. I've also try with Edge browser.
As you can see in the print screen Interface is in french but formula german!?!?!?!?!?
AlterMind64 I had the same issue. Changed language settings in OneDrive - but also cleared by cache (cookies). Works for me.
- Hi Fabrice, Did you contact Microsoft as you intended to ? If yes was it through a forum where I can catch up with your thread ? Thanks for the update ! Best regards, AlterMind
- Hi Sergei, As you've been providing the most useful answer in this thread, I was wondering if you had finally heard of any solution from Microsoft to this language / region / locale mess in Office 365 mixing it all and leaving the users with unusable language settings (like assuming a default language for Excel formulas or MSN content in multilingual countries like Switzerland or Belgium, etc ? I've spent already hours searching for a solution and that *exact* same issue was already present in 2013 and I've completely lost any hope of seeing this corrected any time... Any update you've heard of ? Best regards. AlterMind
Would be awesome if there is some way this doesn't need to be pages long of people still not knowing how to change this. I have been on this for hours. Still not clear. I have searched hours, signed up for multiple forums on microsoft or office online of 365 or onedrive (talk about uniformity wow) and there is still no definitive answer on this seemingly simple problem.
Hello,
I have a similar problem.
I have created an excel sheet with formulas. My excel is in Spanish and the formulas too.
I have to share this Excel file with people from other countries like Italy and Germany. They can open the file but the formulas are not working because are not recognize by their excel.
All of us have the same excel version, Office 365.
What can I do?
Thanks
Did you get a solution? I still have the issue with Excel online. Everything is in English but the functions are in German.
Thanks a lot. I will contact Microsoft.
Have a nice week-end
Fabrice
Hi Fabrice,
I have no O365 Home and can't reproduce, but try this https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_other/excel-online-how-to-change-regional-settings/03862c3c-8f32-42cf-961c-112f0f1fd790
Above is quite old and perhaps menu items changed, but i guess the idea shall work. In your online account settings change in personal info (where birthday, etc) your Country/region from Switzerland on France. When your locale will be changed on French one.
Why Microsoft keeps for Switzerland only German locale that's question to them
I have Office 365 personnal, not buisness
When bit more to clarify
1) You have Office 365 for business subscription
2) You open office.com and when goto OneDrive
3) Here you select Site Settings
4) In Site Settings in Regional settings you have French locale
Correct?
if I try french or english formula, I got #NAME as cell value
