IBM PAFE Add-ins Issue - Classic add-in reappears, New add-in fails to appear, New add-in fails to register for PAX API
Posted: Thu Dec 16, 2021 7:16 pm
Ran into an issue regarding IBM Planning Analytics for Excel (PAX/PAFE) that I wanted to document for the benefit of others.
Specific symptoms include:
and:
Specific symptoms include:
- Although uninstalled, legacy PAFE Excel Add-ins: CognosOfficeBI and CognosOfficeTM1, remain enabled (checked on Excel Add-ins list). Even after disabling (unchecking on Excel Add-ins list) post uninstall, re-opening Excel causes each to reappear on the Excel Add-ins list in an enabled but non-functional state.
- Although enabled (checked on Excel Add-ins list), the current PAFE ribbon tab does not appear after the startup of Excel.
Code: Select all
HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Excel\Options
- Remove registry entries named “OPEN*” referencing (A) above. This permanently removes the uninstalled add-ins from the Excel startup process and the add-ins list.
- Excel stops scanning for Add-ins to open during Excel startup when it encounters an “OPEN*” entry with (blank) data. Modify “OPEN*” registry entries so there are no (blank) values. Additionally, the list of add-ins shown in the registry must be continuous e.g. OPEN -> OPEN1 -> OPEN2, etc. rather than discontinuous OPEN -> OPEN2 -> OPEN4, etc.