User launches Controller. User clicks on 'Excel' shortcut icon (on menu bar). User receives error message. In addition, if the user launches Excel, there is no 'Controller' Add-in located on the Microsoft Excel menu bar.
The Excel-link is not installed
There are many different potential causes for this error message.
- TIP: For a list of many other potential causes, see separate IBM Technote #1396195.
This specific IBM Technote deals with the scenario where the problem is caused by some required third-party (Microsoft) prerequisites are not available on the client device.
- Specifically, the Microsoft Office/Excel installation has been a restricted/cut-down/non-default installation, where some of the (required/necessary) 'standard' features/options (such as ".NET Programmability Support") have not been installed.
TIP: In addition, it has been seen that the same problem occurs when the client device has a mixture of Office versions installed. For example, the client device has Office 2003 components (Word, Outlook etc.) installed as well as Office 2007 (Excel).
Resolving The Problem
Ensure that the required subcomponents of 'Office Shared Features' and 'Office Tools' are ticked/installed/enabled inside the Microsoft Office installation routine.
- Method #1 - Modify/change the existing MS Office installation
Assuming that only one version of MS Office is installed, then:
- Launch Control Panel
- Open 'Add or Remove Programs'
- Highlight Microsoft Office 200x
- Click 'Change'
- Inside the section 'Installation Options' ensure that the required sub-components for 'Office Shared Features' and 'Office Tools' are ticked/enabled/installed.
TIP: If you are unsure which components should be installed, simply install *all* subcomponents.
- Method #2 - Perform an uninstall/re-install of MS Office
Alternatively, you can uninstall the current MS Office completely, and then install the MS Office from scratch (making sure you choose all the relevant components during the install wizard).
For example, when installing MS Office 2010 32-bit (64-bit is not supported!) here are the options that the author typically chooses:
...then deselect any unwanted programs, such as:
APPENDIX: If you have two versions of MS Office installed:
This is officially unsupported by IBM. Therefore, please remove one of these. For example, if you had Office 2003 and Office 2007 then:
- Uninstall Microsoft Office 2007 from client PC
- Uninstall Microsoft Office 2003 from client PC
- Install a FULL installation (please choose ALL the optional components for ALL the subcomponents) of Office 2007
- Afterwards, install Office 2007 Service Pack 2
- Afterwards, install the hotfix 'office2007sp2-kb953195-fullfile-en-us.exe '
Was this topic helpful?
15 June 2018