Cognos TM1 9.5.2
Windows 2008 R2 server
Microsoft Excel 2003 (11.5612.5606)
When from TM1WEB select to slice to excel or snapshot to excel, you select “export rows in current page” and “plan_version” for dimensions titles to export. That give a total of 5 new sheets to be generated. You get a error message after some time.
Export in process. Please wait…
A problem occurred while resetting culture settings : Old format or invalid type library. (Exception from HRESULT: 0x80028018 (TYPE_E_INVDATAREAD))
Stop all TM1 services on the Windows server, including the TM1 Excel Service.
For Office 2003 users you must Create a 1033 directory under C:\Program Files\Microsoft Office\Office11. Then, copy excel.exe to the 1033 directory, and rename it as xllex.dll.
For Office 2007 users you must copy (DO NOT CUT) the “xllex.dll” that is in C:\Program Files\Microsoft Office\OFFICE12\1033 into the following directory: C:\Program Files\Microsoft Office\Office12.
For Office 2010 users you must copy (DO NOT CUT) the “xllex.dll” that is in C:\Program Files\Microsoft Office\OFFICE14\1033 into the following directory: C:\Program Files\Microsoft Office\Office14.
Ensure that all TM1 service use the same Windows domain service account.
Start all TM1 service on the Windows server.
Check that your version of Excel is English.
Ensure that Internet explorer uses English (United States) [en-US] as Language Preference,
set in Internet Explorer under TOOLS – INTERNET OPTIONS – GENERAL – LANGUAGES.
Click on ADD to add the English language.
Click on MOVE UP to place English as first language in the list.
Close Internet Explorer
In some cases you need to ensure that Regional settings on the TM1 server for the Windows service account is set to English.
Go to control panel and click on “region and language” settings.
Select format to be English (United States)
If you get a new error after above changes that say
“There was a problem sending the command to the program”
when you start TM1 perspective with Excel 2003 then you must in excel do this;
Go to TOOLS – OPTIONS – GENERAL tab
clear the checkbox for “Ignore other applications”
For Excel 2007 you need to Bring up the Excel options, go to advanced and then scroll down to the “General” section. Make sure that
“Ignore other applications that use Dynamic Data Exchange (DDE)” is not checked.
Now TM1 perspective will work.
The additional workaround for Office 2007 & Office 2010 is slightly different for Office 2003 which is listed in the “KB 320369” article.