IBM Support

IBM Planning Analytics Missing from Excel Ribbon

Troubleshooting


Problem

After installing Planning Analytics for Microsoft Excel the IBM Planning Analytics tab is missing from the ribbon. The add-in can be enabled manually by enabling the following COM Add-in named IBM Framework for Office.

Resolving The Problem

The ability to start an Add-in with Microsoft Excel is controlled by registry setting.

Open the registry editor (regedit.exe) and search for the following registry key named CognosOffice12.Connect.




For each instance of this registry key check for a value named LoadBehavior.



Update the LoadBehavior value to 3 for each instance of this key. This registry key may exist in multiple places in the registry. For example:

MSOffice 32-bit:  HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\Excel\AddIns\CognosOffice12.Connect
MSOffice 64-bit:  HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\Excel\AddIns\CognosOffice12.Connect

HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins\CognosOffice12.Connect

HKEY_USERS\S-1-5-21-581112117-2996542980-2825243346-26575\Software\Microsoft\Office\Excel\Addins\CognosOffice12.Connect

[{"Product":{"code":"SSCTEW","label":"IBM Planning Analytics Local"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Planning Analytics v2.0 for Microsoft Excel","Platform":[{"code":"PF033","label":"Windows"}],"Version":"2.0.3;2.0.2;2.0.1;2.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
12 March 2020

UID

swg22012988