Product:

Cognos TM1 9.5.2

Windows 2008 R2 server

Microsoft Excel 2003 (11.5612.5606)

 

Symptom:

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.

 

Error message:

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))

 

Possible Solution:

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.

Click OK

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)

Click APPLY

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”

Click OK.

 

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.

 

 

More information

The additional workaround for Office 2007 & Office 2010 is slightly different for Office 2003 which is listed in the “KB 320369” article.