IBM Support

Tm1xl.ocx File Not Found Using Perspectives

Troubleshooting


Problem

Attempting to use perspectives result in error

Symptom

This may manifest with one or the other of the following errors.
Run-time error '53':File not found: tm1xl.ocx
Run-time error '53':File not found: tm1prc.dll
tm1xl.ocx File Not Found

Cause

1. Files dll/ocx not register as a result of windows updates
2. Third party add-in
3. Client is using 64bit tm1p.xla rather than 32bit tm1p.xla.

Resolving The Problem

1. Registering tm1xl.ocx and tm1prc.dll within the bin folder.

Run command prompt as administrator

Regsvr32.exe /u <directorypath to>\tm1prc.dll tm1xl.ocx

Regsvr32.exe <directorypath to>\tm1prc.dll tm1xl.ocx

2. Remove third party add-in from Excel

Note: Prerequisites below

[{"Product":{"code":"SS9RXT","label":"Cognos TM1"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"TM1 Perspectives","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.1.1","Edition":"All Editions","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 June 2018

UID

swg21649232