How to set TM1 Perspectives to use Excel 2010

Post Reply
suman23479
Posts: 16
Joined: Fri Jul 29, 2011 6:27 am
OLAP Product: Cognos
Version: 8.4
Excel Version: 12

How to set TM1 Perspectives to use Excel 2010

Post by suman23479 »

Team,
I have Excel 2010 installed on citrix machine and TM1 Prespectives was working fine.
Recently MS 0ffice 2016 was installed on citrix machine and while opening the Prespectives it is opening default to 2016 and prompting the error as attached.
Any help?
Attachments
Capture.PNG
Capture.PNG (29.06 KiB) Viewed 1618 times
declanr
MVP
Posts: 1815
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: How to set TM1 Perspectives to use Excel 2010

Post by declanr »

If you navigate to the tm1p.xla file in the TM1 bin directory (you can get there by right clicking on your perspectives shortcut, "open file location" and then selecting "properties" on the file it takes you to - this will show the bin directory and file path.)

On the tm1p.xla file right click and select properties and then within there you can select what it "opens with".

I have never actually had to do this to make it use a different excel to the standard one used but if you have both installed on the machine then it should work absolutely fine.
Declan Rodger
Post Reply