IBM Support

Tm1xl.ocx File Not Found Using Perspectives



Attempting to use perspectives result in error


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


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