IBM Support

In CAFE, the IBM Cognos tab disappeared

Troubleshooting


Problem

In Cognos Analysis for Microsoft Excel (CAFE), the IBM Cognos tab suddenly vanished and could no longer be seen.

Cause

It is likely that the IBM Cognos tab was being used at the time when Excel stopped functioning for some reason or other. Excel automatically assumes that the current add-in was to blame and disables that add-in, thereby removing the IBM Cognos add-in.

Environment

MS Windows Server 7 Professional
MS Office Professional Plus 2007

Diagnosing The Problem

In Excel, resize window to maximum
> Go to File - Options
In Excel Options, click Add-Ins, and resize window to maximum
~ For Manage, select Disabled Items, click Go…
In Disabled Items, check if the “Addin: ibm cognos office for excel 2007/2010 (cognosofficeshim12.dll)” is in the list of disabled add-ins

Resolving The Problem

If the Excel add-in “IBM Cognos Office for Excel 2007/2010” is disabled then re-enable it to re-display the “IBM Cognos” tab in Excel.

Steps:
* In Excel, go to File - Options
* In Excel Options, click Add-Ins
* For Manage, select Disabled Items, click Go…
* In Disabled Items, select the “Addin: ibm cognos office for excel 2007/2010 (cognosofficeshim12.dll)”, click Enable and then click Close
* Restart Excel

[{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Cognos Analysis for Microsoft Excel","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.1;10.1.1;10.2;10.2.1;10.2.2","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Product Synonym

CAFE XLS XLSX

Document Information

Modified date:
15 June 2018

UID

swg21975520

Page Feedback