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).
Since you already have a Tech Support track open on this, you're already doing the proper action to lead to a resolution. The way that this feature works: SAS Enterprise Guide launches Excel and automates the Excel interface to create a workbook, then adds all of the rows to a sheet within that workbook. The SAS Enterprise Guide process is communicating with the Microsoft Excel process. If the two processes have different locale settings, it's possible that some locale-sensitive values (dates, formatted number values) can get confused during the transfer. Other methods of creating Excel sheets from EG include: - Export data (one time) to Excel - Export data (as a step) to Excel - (program method in Base SAS), then download the resulting XLSX file.
Hello Chris, thank you for your reply. Regarding your first post: it is not related to MS product; also Send to Excel an empty output table 2x5 gives the same error; on two identical workstations: on the one with EG 5.1 Send to Excel works properly, on the one with EG 7.11 it does not.
No-registration upload of files up to 250MB. Not available in some countries. Download the free trial version below to get started. Double-click the downloaded file to install the software. Watch32 - Watch Movies on Watch32.com - Watch32 is the Biggest Library of free Full Movies. Watch 32 Movies Online.
Nov 10, 2015. If you're deploying Microsoft Office 2016 to client systems, you'll first need to build an MSP file using the Office Customization Toolkit (OCT) for OS. For my lab environment, I have a software file share on a file server, and I've created separate x86 and x64 folders inside my Office_2016 folder to store both.
All MS software is identical on both machines. They are clean built from the scratch just for this debug.
![Office Office](https://4sysops.com/wp-content/uploads/2015/11/Installing-Office-2016-using-the-adminfile-switch-and-an-MSP-file.png)
Soon or late someone in a multilingual envoronment will complain for this. I'm working for a community here, not just for me, I hope you understand my spirit. Regarding your second post: The 'culture trick ' does not work because the Send To Excel gives the same error thank you regards PS: it is a SAS EG bug, if it is the last thing I say.