Display language not changing in Office 2007. I live and work in South Korea as an English teacher. I have successfully changed the display language for Win 7 Enterprise and Office 2010 to English so I can use it for my lessons and general work. The 2007 Microsoft Office suite Service Pack 3 (SP3) and Microsoft Office Language Pack 2007 SP3 provide the latest updates to the 2007 Office suite and to Office Language Pack 2007. These updates include two main categories of fixes: Previously unreleased fixes that were made specifically for this service pack.
Microsoft Office 2007 comes in different languages. This includes different formula names in Excel, e.g. =Summewenn instead of =sumif. This is quite inconvenient if you're used to the English names or your training material uses those.
I have a German Windows 7 and Office 2007 Professional Plus because I bought them in Germany. I would like to change as much as necessary to English in order to get English Excel formulas and preferably also menu items.
Install Free Microsoft Office 2007
I went to Excel Options/Language Settings (Spracheinstellungen) - this is the same as what you get through Windows Start/Microsoft Office Tools. There was no Display Language tab and no check box to uncheck to use the Windows system language. On the tab 'Bearbeitungssprachen' I was able to select English (US) as primary interface language. This setting had no effect whatsoever.
After some research, I tried the following Registry changes:
- HKCU/Software/Microsoft/Office/12.0/Common/LanguageResources
- set UILanguage to 0409 - changed back to 0407 at start of Excel
- set InstallLanguage to 409 - no effect
- HKLM/System/ControlSet001/Control/NIs/Language
- set (Standard) to 0409 (from no value) - no effect
- set Default to 0409 - remains so but has no effect
- set InstallLanguage to 0409 - changes back to 0407 at boot
0407 is the language code for German, 0409 the one for English.
I also tried to uninstall and reinstall Office but there is no option to change the language.
What do I need to do in order to get English formulas and preferably menus?
2 Answers
Microsoft Office 2007 Display Language Download Windows 7
You need a language pack, which unfortunately are no longer for sale (according to a blog) for office 2007. Your best bet is a new Office license.
R-DHow To Change Office 2007 Display Language
R-DIf you do not find the Display Language tab the language you want is not installed. With Vista I copied the 1033 file from my laptop which had it and pasted it next to to the 1043 file in 'programs'.
Next is a registry change:
- Run 'regedit' and look for: HKEY_CURRENT_USERSoftwareMicrosoftOffice12CommonLanguageResources(The above '12' is for 2007, you do not mention your system version)
- You will see possibly three codes: (Default), 1033 and another that you are trying to set.
- Right click the Default and 1033 (English US) and change to Off.
- If the language code that you do want is not there, right click Enabled Languages, New, String Value and type in the code (from the website above) and type On in the Value Data.
I would then do a reboot to reset everything, now in the LanguageRegion Settings either the langauges are not showing or you can now remove them and they should remain removed.
Microsoft Office 2007 Language Setting
Please note that 1033 is English(US) 1043 is dutch, you should see the german number
MJH