Cognos Controller 10.1.1
Windows 2008 R2 Server
Office 2010 excel
When you start excel from inside Cognos Controller you get error message.
The error is before Excel is started on the Citrix server, as you can see in Citrix Program Neighborhood Connection Center.
The Excel-link is not installed.
Visual Basic For Application is not installed or deactivate on the Citrix server.
Cognos Controller Excel add in demands that Visual Basic For Applications is enabled.
Login to Citrix server as Local Administrator
Go to Control panel
Go to programs and features
Right-Click on Microsoft Office 2010 and select change
Select Add/remove features
Check that Visual Basic for Applications is installed.
If you start Excel and check if the controller link is installed, if the VBA support is disabled then the controller link is shown as controllerXL.xll inside excel add-in dialog, under File menu – Excel Options. If VBA support is enabled then it will show “IBM Cognos Controller Link” inside excel add-in dialog.
When you are inside Excel, press ALT+F11 to active the Visual Basic editor. If this does not work, then the VBA support is disabled in your excel installation. Cognos Controller excel link demands that the VBA support is working in excel before Cognos Controller can work.
There can be a group policy that have deactivate the VBA support in Microsoft Office.
On the citrix server;
Go to start menu
Go to RUN
Expand tree to [HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Common]
If the value for vbaoff is 1 , then Visual Basic for Applications is disabled in Excel 2010.
Change the value to 0 (zero)
Test the Cognos Contoller Excel link again.
If you do not find the GPO that set the value, you can add below text to a file named vbaon.reg and include the file in a login script on the Citrix server to set it on the user profile.
Windows Registry Editor Version 5.00