Hello, I just post this here to have some volunteers to confirm this or reject it. A support ticket was already open. Please, be so kind to read carefully all the post before arguing or testing. ########## Begin of report ######### **Issue description: When click on "Send To Excel" you receive the following error message: "Old format or invalid type library. (Exception from HRESULT: 0x80028018 (TYPE_E_INVDATAREAD))" The function "Send to Word" works properly. **Reason: This happens only if the OS display language [Control Panel->Region and Language->TAB Keyboards and Languages->Choose display language] does not match the Format [Control Panel->Region and Language->TAB Formats->Format] All the other settings in Region and Language are irrelevant in the issue (e.g., the "locale" is not relevant to match). **Very Important Note: 1- Under the same system requirements and conditions, Enterprise Guide 5.1 x64 is not affected 2- The Microsoft suggested workarounds for this Excel error as posted here https://support.microsoft.com/en-us/kb/320369 are not working or not applicable **Affected products: Enterprise Guide 7.11 x64, the patching level of the OS or EG is not relevant Maybe also EG 7.1 is affected (?) **System requirements: MS Office 32 bit, 2010 or 2013 with Multi Language Packs (MUI) installed Windows 7 x64, with extra language packs installed A remote SAS 9.3 server **How to reproduce the issue: You can test by switching the Format (logoff not required) and/or the OS Display Language (this requires a logoff) but only between languages that are installed as both MUI for MS Office and OS Language Pack (which gives you the option to change the OS Display Language). Between changes you have to close EG. Example: you have Win 7 in English and MS Office in English, and because the company has also German users, the workstations are deployed also with the MS Office MUI in German and the Windows 7 German Language Pack. Assumed that your current OS Display Language and Format are English: Open EG 7.11 x64, connect to a SAS server, open a table and "Send To Excel". This should work properly. Close EG, change the OS Display Language (you are supposed to understand the other language) but do not change the Format, logoff; open EG 7.11 x64 "Send to Excel"; it should fail now and display the error reported above. Close EG, go to Control Panel->Region and Language->TAB Formats->Format: German(Austria) -> Apply, OK Open EG 7.11 x64, "Send To Excel". This should work properly now. **Workaround ---->This workaround is absolutely not suggested for production Always match the Format and the OS Display Language NOTE: matching the Format and OS Display Language just for some users it is in most cases not a workaround because the company Format might be required to be the same on any system (and so should be the "locale") for the current Area/Country/Nation or globally, while the OS Display Language may differ. So, it might be that the Format must be English UK for all the users because the company office is located in London but some users need another OS Display Language. In this case the EG will give the error reported above. ########## End of report ######### I administer multicultural user groups. Some users need OS Display Language set to English and some users need it set to German, but the Format must stay "German (Austria)". Because EG 5.1 is not affected, I cannot rollout EG 7.11 to proceed after to upgrade from SAS 9.3 to SAS 9.4: the departments will complain for the "Send to Excel" error. Regards Digitmaster
... View more