You have not logged in

Product:
Cognos Controller 10.4.2
Microsoft Windows 2016 server

Issue:
Working in a excel file with fgetval formulas, but even do – i is logged into Cognos Controller, the cell show “You have not logged in”.

Solution:

Check if it will update the values if you press F9.

Otherwise check your formulas carefully in your spreadsheet, as if they are wrong you will get this error.

If it is only one spreadsheet that does not work, it is probably a misspelled formula in that sheet.

More information:

https://www.ibm.com/docs/en/cognos-controller/10.4.2?topic=excel-cognos-controller-functions-in-microsoft