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.
Any ideas what's going on and how to resolve this?
Thanks
Kaz
Perspectives button disabled TM1 10.2.2 & Excel 2016
-
- Posts: 95
- Joined: Mon Jun 25, 2012 6:58 am
- OLAP Product: TM1, SSAS, Power BI
- Version: 10.2.2
- Excel Version: 2016
- jim wood
- Site Admin
- Posts: 3951
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
Re: Perspectives button disabled TM1 10.2.2 & Excel 2016
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.
Jim.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
-
- Posts: 95
- Joined: Mon Jun 25, 2012 6:58 am
- OLAP Product: TM1, SSAS, Power BI
- Version: 10.2.2
- Excel Version: 2016
Re: Perspectives button disabled TM1 10.2.2 & Excel 2016
Hi Jim,
It is set to Enable all macros. Thanks
Kaz
Thanks,
Kaz
Kaz
- jim wood
- Site Admin
- Posts: 3951
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
Re: Perspectives button disabled TM1 10.2.2 & Excel 2016
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.
Jim.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
-
- Posts: 95
- Joined: Mon Jun 25, 2012 6:58 am
- OLAP Product: TM1, SSAS, Power BI
- Version: 10.2.2
- Excel Version: 2016
Re: Perspectives button disabled TM1 10.2.2 & Excel 2016
Thanks for the reply Jim.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.
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
Kaz
- jim wood
- Site Admin
- Posts: 3951
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
Re: Perspectives button disabled TM1 10.2.2 & Excel 2016
Always knew google had good tastekaazimraza wrote: ↑Tue Sep 05, 2017 3:31 pm Gmail decided to send notifications relating to your posts into Spam!
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7