IBM Support

F9 does not work (Excel spreadsheet does not update/run) unless user logged into Controller Excel link

Troubleshooting


Problem

User launches Excel, but does NOT logon (authenticate) to the Controller Excel add-in.

- User opens a spreadsheet. User presses F9.

- The user expects that the spreadsheet/report should run. However, nothing happens (the values do not change).

Symptom

Example:

Imagine a scenario where

- User creates a new workbook, and creates a simple Excel summation

- User changes Excel 'Calculations' to be 'Manual'

- User changes a value (within the summation range) and presses F9 (on their keyboard)

=> User sees the "Analyzing sheet, please wait....." message. However, it does not change the value of the formula! (bad)

 

If a user now:

- clicks on the 'Controller' add-in

- clicks 'Log On', and logs onto Controller

- then press F9

=> This time the formula value updates/changes correctly (good)

 

If the user now:

- Logs off from Controller Excel add-in (by clicking 'Log Off' inside add-in menu bar), but keeps Excel open/running (same Excel session)
- Changes a value within the summation range

=> The formula value changes/updates as expected (correctly) (good)

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Component":"","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.3.1","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

Modified date:
09 May 2025

UID

ibm10728609

Page Feedback