Mar 28 2017
11:57 PM
- last edited on
Jul 25 2018
09:30 AM
by
TechCommunityAP
Mar 28 2017
11:57 PM
- last edited on
Jul 25 2018
09:30 AM
by
TechCommunityAP
Hello,
I'm from Switzerland and we speak 3 different languages. Mine is french but the most important is german. I use excel online, the menu is in french, no problem. But when I want to enter a formula, I have to type it in german. That's a problem for me. I didn't find how to change it. Please help me.
Thanx
Fabrice
Mar 29 2017 01:20 AM
Hi Fabrice,
You have to change your regional settings (locale) on French. For Excel Online that's actually settings for OneDrive (open it, find Site Settings, when Regional Settings).
For O365 Home (or other personal subscription) that's most probably is under My Account, not sure.
Mar 29 2017 01:31 AM
Hi Sergei,
Thanx for answer. Unfortunately, I've already try personnal settings and I found nothing. Please give me a print screen or a step by step explaination because I find no solutions.
Mar 29 2017 01:58 AM
Okay, for any business one
1) Open OneDrive from the launcher
2) Settings
3) Regional
4) Locale
Mar 29 2017 04:14 AM
Hello
Sorry I'm not buisiness one user. My interface is not like yours...
Mar 29 2017 04:15 AM
I think it's a bug in Office Online, because my language is french, Excel functions should be in french.
Mar 29 2017 04:32 AM
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.
Mar 29 2017 05:30 AM
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!?!?!?!?!?
Mar 29 2017 05:31 AM
if I try french or english formula, I got #NAME as cell value
Mar 29 2017 07:10 AM
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?
Mar 30 2017 04:27 AM
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-chan...
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
Mar 31 2017 02:57 AM
Thanks a lot. I will contact Microsoft.
Have a nice week-end
Fabrice
Dec 07 2018 02:39 PM
Did you get a solution? I still have the issue with Excel online. Everything is in English but the functions are in German.
Apr 05 2019 08:15 AM
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
Apr 20 2019 02:43 AM
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.
Apr 22 2019 03:20 PM
Apr 22 2019 03:22 PM - edited Apr 22 2019 03:23 PM
May 26 2019 04:14 AM
@AlterMind64 I had the same issue. Changed language settings in OneDrive - but also cleared by cache (cookies). Works for me.