Perspectives not working -- tm1xl.ocx not found

Post Reply
jpjosey
Posts: 5
Joined: Thu Jan 28, 2016 10:56 am
OLAP Product: TM1
Version: 10.2
Excel Version: 2013 Pro 64b

Perspectives not working -- tm1xl.ocx not found

Post by jpjosey »

Greetings

I get the following error message immediately when loading perspectives, it prevents perspectives from loading at all;
Microsoft Visual Basic
Run-time error '53':
File not found: tm1xl.ocx
I have 64b TM1 10.2.2 and 64b Excel 2013 installed.

I've reinstalled both as administrator (a couple of times now).

IBM support suggests manually un/reregistering a couple of .dll's, done that. Still getting nothing.

I also manually installed the vcredist package as suggested.

The files are all there in the install folder. There's this old thread, which didn't really give me anything to work with.

Anyone else had this issue who can advise me where to step next?

FYI we have the same software on multiple PC's that gets rolled out by our IT, and only on mine am I getting this problem. Got a fresh image and install of everything a couple of weeks ago and haven't had perspectives since.

Thanks
declanr
MVP
Posts: 1828
Joined: Mon Dec 05, 2011 11:51 am
OLAP Product: Cognos TM1
Version: PA2.0 and most of the old ones
Excel Version: All of em
Location: Manchester, United Kingdom
Contact:

Re: Perspectives not working -- tm1xl.ocx not found

Post by declanr »

Josey!

Did you install 64 bit perspectives?
Chances are it might be the 32 bit version.
Declan Rodger
Guillaume Galtier
Posts: 40
Joined: Thu Jun 19, 2008 8:09 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2010

Re: Perspectives not working -- tm1xl.ocx not found

Post by Guillaume Galtier »

Hi jpjosey,

We already faced this kind of issue and registering the dlls didn't work at all.

The problem was coming from a conflict with another Excel add-in: Business Object Live Office Add-In
We fixed the issue deactivating this add-in.

Hope that helps

Guillaume
jpjosey
Posts: 5
Joined: Thu Jan 28, 2016 10:56 am
OLAP Product: TM1
Version: 10.2
Excel Version: 2013 Pro 64b

Re: Perspectives not working -- tm1xl.ocx not found

Post by jpjosey »

Thanks for the hints guys. Just been to busy to experiment lately, have got servers I can remote onto for Perspectives use for now. Will follow up in this thread if I ever do get any further along with this problem.
Post Reply