PA for Excel 2.0.3 - not appearing in the Ribbon- not working
-
- Posts: 18
- Joined: Tue Dec 12, 2017 2:57 pm
- OLAP Product: TM1
- Version: PA 2.0
- Excel Version: Excel 2016
PA for Excel 2.0.3 - not appearing in the Ribbon- not working
Hello,
I am currently Planning Analytics 2.0 user in my PC and Perspectives run in PC very well.
Then I try to install PAx. Even though my setup finished successfully, I cannot see the IBM PA ribbon in Excel and I cannot solve the problem by searching in Google. If you have any help, I am thankful.
As a side note,
My Excel is Excel 2016,32-bit and I installed 32-bit version of PAx.
I have full components of TM1 like Architect, Perspective, Insight, etc.
I did not install anything other than PAx 2.0.3.
Regards to all.
https://imgur.com/a/xtdKF
I am currently Planning Analytics 2.0 user in my PC and Perspectives run in PC very well.
Then I try to install PAx. Even though my setup finished successfully, I cannot see the IBM PA ribbon in Excel and I cannot solve the problem by searching in Google. If you have any help, I am thankful.
As a side note,
My Excel is Excel 2016,32-bit and I installed 32-bit version of PAx.
I have full components of TM1 like Architect, Perspective, Insight, etc.
I did not install anything other than PAx 2.0.3.
Regards to all.
https://imgur.com/a/xtdKF
Last edited by My24 on Thu Dec 14, 2017 8:29 am, edited 1 time in total.
-
- Community Contributor
- Posts: 247
- Joined: Tue Nov 01, 2011 10:31 am
- OLAP Product: TM1
- Version: All
- Excel Version: All
- Location: Manchester
- Contact:
Re: PA for Excel 2.0.3 - not appearing in the Ribbon- not working
Are you opening Planning Analytics for Excel (from the Stat menu) or are you opening Excel?
Have you configured Excel to load the Planning Analytics for Excel add-in on startup?
Have you configured Excel to load the Planning Analytics for Excel add-in on startup?
-
- Posts: 18
- Joined: Tue Dec 12, 2017 2:57 pm
- OLAP Product: TM1
- Version: PA 2.0
- Excel Version: Excel 2016
Re: PA for Excel 2.0.3 - not appearing in the Ribbon- not working
There is no Planning Analytics for Excel in the Start menu.Edward Stuart wrote: ↑Wed Dec 13, 2017 9:16 am Are you opening Planning Analytics for Excel (from the Stat menu) or are you opening Excel?
Have you configured Excel to load the Planning Analytics for Excel add-in on startup?
So, I directly open Excel.
I can see IBM Cognos Office Reporting BI and TM1 Addin in the Options > Add ins tab, but I cannot use and see IBM Planning Analytics ribbon.
Yes, I think I configured it by from Add-ins section.
https://imgur.com/a/zRuqQ
-
- Community Contributor
- Posts: 286
- Joined: Fri Feb 15, 2013 5:49 pm
- OLAP Product: TM1
- Version: PA 2.0.9.1
- Excel Version: 365
- Location: Minneapolis, USA
Re: PA for Excel 2.0.3 - not appearing in the Ribbon- not working
Did you also check it was enabled in your COM addins?
Am I reading correctly that you're running TM1 10.2.2 and not Planning Analytics? If that's the case, I believe the excel add-in is a different product: CAFE.
Am I reading correctly that you're running TM1 10.2.2 and not Planning Analytics? If that's the case, I believe the excel add-in is a different product: CAFE.
-
- Posts: 15
- Joined: Wed May 25, 2011 12:39 pm
- OLAP Product: TM1
- Version: 1022-FP*
- Excel Version: 2010-2016
Re: PA for Excel 2.0.3 - not appearing in the Ribbon- not working
Check log file, where PAX was installed. PAx has two nested installers, and if you using custom excel(or PAx) destination folder, the nested one will go crazy)
-
- Posts: 18
- Joined: Tue Dec 12, 2017 2:57 pm
- OLAP Product: TM1
- Version: PA 2.0
- Excel Version: Excel 2016
Re: PA for Excel 2.0.3 - not appearing in the Ribbon- not working
Thank you asscheevel. I go to COM Addins, and activated IBM Framework for Office and problem solved.
Also I learned later that I am using Planning Analytics 2.0 right now, not TM1 10.2.2. I am beginner, sorry.
Thanks as well.
-
- Community Contributor
- Posts: 286
- Joined: Fri Feb 15, 2013 5:49 pm
- OLAP Product: TM1
- Version: PA 2.0.9.1
- Excel Version: 365
- Location: Minneapolis, USA
Re: PA for Excel 2.0.3 - not appearing in the Ribbon- not working
Glad the COM add-in fixed your issue. We've run into issues with CAFE and PAX where the add-in load behavior will switch from automatic to manual and we need to go into the registry editor and manually change the load behavior of the add-in; otherwise the users need to go into their add-ins options and re-enable the add-in every time they start excel. It's become so much of an issue with some of our users, that I now have a batch file to automatically reset the load behavior in a users registry.
-
- Posts: 5
- Joined: Thu Dec 05, 2019 9:50 pm
- OLAP Product: TM1 Planning Analytics
- Version: 2.06
- Excel Version: 2016
Re: PA for Excel 2.0.3 - not appearing in the Ribbon- not working
I am having this same issue but not seeing IBM in the Add-ins. Would you have another possible suggestion? I have checked the Microsoft pre-requisites and the laptop passes. I am installing on a 64 bit windows laptop and seems may be the CAFE install of PAX 2.0.8ascheevel wrote: ↑Thu Dec 14, 2017 8:48 am Glad the COM add-in fixed your issue. We've run into issues with CAFE and PAX where the add-in load behavior will switch from automatic to manual and we need to go into the registry editor and manually change the load behavior of the add-in; otherwise the users need to go into their add-ins options and re-enable the add-in every time they start excel. It's become so much of an issue with some of our users, that I now have a batch file to automatically reset the load behavior in a users registry.
-
- Community Contributor
- Posts: 286
- Joined: Fri Feb 15, 2013 5:49 pm
- OLAP Product: TM1
- Version: PA 2.0.9.1
- Excel Version: 365
- Location: Minneapolis, USA
Re: PA for Excel 2.0.3 - not appearing in the Ribbon- not working
If you're not seeing the PAX add-in in your list of add-ins in excel, it would suggest that you don't have it installed properly. You mention you have a 64 bit windows install, but do you know if you have 32 or 64 bit excel installed? There are 32 and 64 bit versions of the PAX add-in and you'd want to be sure you're installing the correct one based on your excel install.
-
- Posts: 5
- Joined: Thu Dec 05, 2019 9:50 pm
- OLAP Product: TM1 Planning Analytics
- Version: 2.06
- Excel Version: 2016
Re: PA for Excel 2.0.3 - not appearing in the Ribbon- not working
It was a 64 bit installed to the 64 Operating system.
I ended up just re-installing it to fix the issue.
Thank you though.
I ended up just re-installing it to fix the issue.
Thank you though.