Cognos Controller 10.4.2
Microsoft Excel 2013
Microsoft Windows 2019 server
Data entry does not work in Cognos Controller Client for a few users on the Citrix platform.
ControllerForms12 … Object variable or With block variable Object reference not set … ActivateDataEntryForm…
Error launching menu item “Controller Link”
Unable to get the FullName property of the addin class at System.Runtime.Type.ForwardCallToInvokeMember .. a WrapperTypes.
Open Excel that is used with Cognos Controller for the user who have issues.
Go to Options – Add-ins, click on the Go button at the bottom for Excel Add-Ins.
Uncheck the link for “Cognos Controller Link for Microsoft Excel” add-in, press OK, and exit excel.
Log off Citrix session and log off Citrix Connection Center.
Log out from your computer and log in again.
Start Excel in Citrix as before.
Go to Options – Add-ins – Go button for Excel Add-ins.
Click on Browse
Find C:\Program Files\ibm\IBM Cognos Controller Local Client\adxloader.Controller.ExcelLink.dll
On question that “a file named C:\Program Files\ibm\IBM Cognos Controller Local Client\adxloader.Controller.ExcelLink.dll already exists in this location. Do you want to replace it?” Click YES.
Remove any other add in, that can interfere, like Thinkcell.
Start Cognos Controller client and try again.
Ensure the user have the same version of Excel on Citrix as on other Citrix servers or on her laptop.