IBM Support

** Troubleshooting ** User is not automatically logged into Excel link when launching functionality from main Controller program (CCR.EXE)

Troubleshooting


Problem

User launches the main Controller program (CCR.EXE). User logs onto database. User then launches an Excel-based piece of functionality (for example clicking 'Controller Link' X button). However, when Excel opens, the user finds that he/she is not logged onto Controller (inside the Excel link).

Symptom

Example #1:

User clicks "Excel link" shortcut icon (on Controller taskbar):


Excel opens, but if user clicks "Add-ins" and then "Controller" they find that the 'Log on..' button is active:

image-20180926171728-1

This is unexpected. The expected result is that it should be greyed out. Therefore, the user is not logged onto Controller inside the Excel link.

 

Example #2:

User clicks "Company - Data Entry - Reported Values". User makes selections, and clicks "open". As expected, Excel launches. However, the form never appears (and the user is not logged onto the Excel link).

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Component":"Controller","Platform":[{"code":"PF033","label":"Windows"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSMRTZ","label":"IBM Cognos Controller on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

More support for:
IBM Cognos Controller

Software version:
All Versions

Operating system(s):
Windows

Document number:
262613

Modified date:
08 May 2025

UID

swg21883547

Manage My Notification Subscriptions