Perspectives button disabled TM1 10.2.2 & Excel 2016

Post Reply
kaazimraza
Posts: 77
Joined: Mon Jun 25, 2012 6:58 am
OLAP Product: TM1, SSAS, Power BI
Version: 10.0.1
Excel Version: 2007 2010

Perspectives button disabled TM1 10.2.2 & Excel 2016

Post by kaazimraza » Thu Aug 31, 2017 9:01 am

Hi all,

We are in the mid of upgrading from TM1 10.1.1 to TM1 10.2.2, with FP6. TM1 Perspectives work as expected, for almost all features, when we use Excel 2010. However; when accessing the same server from Excel 2016, even after logging on to the server, there's no change in Perspectives' buttons' state. All buttons are disabled, and the status of server circle does not change from red to green.
TM 10.2.2 Perspectives Excel 2016.png
TM 10.2.2 Perspectives Excel 2016.png (30.97 KiB) Viewed 337 times
tm1_10.2.2_perspectives_excel_2010.png
tm1_10.2.2_perspectives_excel_2010.png (63.58 KiB) Viewed 337 times
Any ideas what's going on and how to resolve this?

Thanks
Kaz
Thanks,

Kaz

User avatar
jim wood
Site Admin
Posts: 3510
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: TM1 10.2.2
Excel Version: 2007
Location: 1639 Route 10, Suite 107, Parsippany, NJ, USA
Contact:

Re: Perspectives button disabled TM1 10.2.2 & Excel 2016

Post by jim wood » Thu Aug 31, 2017 11:32 am

What's the macro security level set to? I'm not certain it could have something to do with it but it's something worth looking at,

Jim.
Struggling through the quagmire of life to reach the other side of who knows where.
Application Consulting Group (ACG) TM1 Consulting
OS: Windows 7 64-bit. TM1 Version: 10.1.1

kaazimraza
Posts: 77
Joined: Mon Jun 25, 2012 6:58 am
OLAP Product: TM1, SSAS, Power BI
Version: 10.0.1
Excel Version: 2007 2010

Re: Perspectives button disabled TM1 10.2.2 & Excel 2016

Post by kaazimraza » Fri Sep 01, 2017 2:59 am

jim wood wrote:
Thu Aug 31, 2017 11:32 am
What's the macro security level set to? I'm not certain it could have something to do with it but it's something worth looking at,

Jim.
Hi Jim,

It is set to Enable all macros.
Excel_2016_Macro_Security_Level.png
Excel_2016_Macro_Security_Level.png (31.53 KiB) Viewed 305 times
Thanks
Kaz
Thanks,

Kaz

User avatar
jim wood
Site Admin
Posts: 3510
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: TM1 10.2.2
Excel Version: 2007
Location: 1639 Route 10, Suite 107, Parsippany, NJ, USA
Contact:

Re: Perspectives button disabled TM1 10.2.2 & Excel 2016

Post by jim wood » Fri Sep 01, 2017 12:18 pm

I actually did a full upgrade to 10.2.2 FP7 yesterday. I didn't see this at all. This was after a fresh install of Office 2016 as well. Are you sure you've installed the correct version? You haven't installed the 64 bit version of the client on a 32 bit version of excel?

Jim.
Struggling through the quagmire of life to reach the other side of who knows where.
Application Consulting Group (ACG) TM1 Consulting
OS: Windows 7 64-bit. TM1 Version: 10.1.1

kaazimraza
Posts: 77
Joined: Mon Jun 25, 2012 6:58 am
OLAP Product: TM1, SSAS, Power BI
Version: 10.0.1
Excel Version: 2007 2010

Re: Perspectives button disabled TM1 10.2.2 & Excel 2016

Post by kaazimraza » Tue Sep 05, 2017 3:31 pm

jim wood wrote:
Fri Sep 01, 2017 12:18 pm
I actually did a full upgrade to 10.2.2 FP7 yesterday. I didn't see this at all. This was after a fresh install of Office 2016 as well. Are you sure you've installed the correct version? You haven't installed the 64 bit version of the client on a 32 bit version of excel?

Jim.
Thanks for the reply Jim.

I have got multiple machines with Excel 2016 installed, both 64 bit & 32 bit and a blend of Windows flavors, Server 2012, Windows 10 Pro and Windows 7 Pro. All Windows 10 Pro machines are loaded with 32 bit installers, and IT doesn't even know that 64 bit version even exists. So chances are slim that there's a mismatch of architecture here but nevertheless, I am going to give it a check tomorrow.

I've been talking to IBM support and they think it's misbehaving because machines with TM1 Server & Excel 2010 have TM1 10.2.2 FP6 IF6 while the machine with Excel 2016 is on FP6 only, no IF6.

P.S: Excuse me for delayed reply, for some reason, Gmail decided to send notifications relating to your posts into Spam!

Thanks
Kaz
Thanks,

Kaz

User avatar
jim wood
Site Admin
Posts: 3510
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: TM1 10.2.2
Excel Version: 2007
Location: 1639 Route 10, Suite 107, Parsippany, NJ, USA
Contact:

Re: Perspectives button disabled TM1 10.2.2 & Excel 2016

Post by jim wood » Tue Sep 05, 2017 7:46 pm

kaazimraza wrote:
Tue Sep 05, 2017 3:31 pm
Gmail decided to send notifications relating to your posts into Spam!
Always knew google had good taste :)
Struggling through the quagmire of life to reach the other side of who knows where.
Application Consulting Group (ACG) TM1 Consulting
OS: Windows 7 64-bit. TM1 Version: 10.1.1

Post Reply