IBM Support

IBM Planning Analytics Missing from Excel Ribbon

Technote (troubleshooting)


Problem(Abstract)

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:

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\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

Document information

More support for: IBM Planning Analytics Local
Planning Analytics v2.0 for Microsoft Excel

Software version: 2.0, 2.0.1, 2.0.2, 2.0.3

Operating system(s): Windows

Reference #: 2012988

Modified date: 26 January 2018