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?
How to set TM1 Perspectives to use Excel 2010
-
- 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
- Attachments
-
- Capture.PNG (29.06 KiB) Viewed 1644 times
-
- 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
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.
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