We have an application that, amongst many other things, has an export to Excel function. This uses the Excel COM interface and simply exports some data to a new sheet in Excel and formats it to look like where it came from. For years we known that if the machine locale is set to something different to what Office was installed under that an "old format or invalid type library" will arise. However, under Excel 2003 it was possible to download and install a MUI (multi-language user interface) pack to fix the problem. With Excel 2007 and later there does not seem to be the equivalent pack - there are language packs (we downloaded a 7GB pack from MSDN for Office 2007) but these either don't work (setup.exe is "corrupted"), or don't work in the sense that we still get the "old format or invalid type library" problem.
When you view your list of registered languages, you will see a list of detected languages. However, you will often see two or more sets of languages on that list. For example, you may have languages like Slovak, Czech, and Hungarian, in addition to the native English language you were originally using. This is the result of a Windows update that changed the valid languages for your system. Before you install Office, make sure you only have one language on the list.
If Office cannot detect your language settings, you may want to download and install an Office 2007 Multi-language User Interface (MUI) Pack. Depending on your installation memory, it could take a while to download.
The language pack allows you to install or distribute the component consistently across your organization. If you are unfamiliar with the process, see Installing Localization Apps for Office for installation details.
Although the first base language pack (English language for Windows Server 2012) did not include MS Office 2003, Microsoft made the base language pack available in subsequent revisions of Windows Server. This package includes all of the language packs necessary for Windows Server 2016. d2c66b5586