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.
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
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
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"}}]
Was this topic helpful?
Document Information
Modified date:
12 March 2020
UID
swg22012988