Perspectives Ribbon Missing on Excel 2016 (Office 365)

Post Reply
jwafro
Posts: 25
Joined: Thu Sep 07, 2017 8:31 am
OLAP Product: TM1
Version: 10.2.2 / 9.5.1
Excel Version: 2003 2010

Perspectives Ribbon Missing on Excel 2016 (Office 365)

Post by jwafro »

Hi,

My client has recently upgraded user hardware to Windows 10 / Office 365 (click to run, 64 Bit)

They installed the 64 bit version of perspectives, which went smoothly.

Apon opening excel, the 'Planning Analytics' navy blue square appears as it should, but the app is not present in the ribbon.

No amount of messing about with the tm1p.xla addin or the ribbon addin gets it to show.
When going into the VBA editor, you can see the tm1p.xla as a project, and TM1 also recognises DBRW as a formula, so I know it is 'there'.

We installed PAX and it appears in the ribbon as expected.
We removed PAX from the machines by uninstall, before attempting Perspectives but is it possible there is still a conflict somehow between the two?

We have enabled Macros etc.

My question is: is there any standard settings that could prevent this from appearing in Excel? - eg Registry or some other IT security settings?


Thanks guys,
Josh
User avatar
paulsimon
MVP
Posts: 808
Joined: Sat Sep 03, 2011 11:10 pm
OLAP Product: TM1
Version: PA 2.0.5
Excel Version: 2016
Contact:

Re: Perspectives Ribbon Missing on Excel 2016 (Office 365)

Post by paulsimon »

Hi

One thing you could try is renaming the TM1PRibbon.xlam file to add a .DISABLED to the end and then restart. If you get an Add Ins Menu showing in the Ribbon, then check to see if you can access TM1 from that.

At our site we gave up trying to use the Ribbon years ago and only use this method now, because the ribbon was always corrupting.

I haven't done extensive testing but it seems that you can access both Perspectives and PAX this way. However, I doubt that it will work if you start doing DBRWs since it won't know whether to user Perspectives or PAX.

Regards

Paul
Post Reply