Troubleshooting
Problem
IBM Planning Analytics for Excel ribbon is not appearing in Excel. You navigate to Excel options to manage the available COM Add-ins then notice that you are not able to check off the "IBM Framework for Office" COM Add-in to make it available.
Symptom
IBM Planning Analytics for Excel ribbon is missing in Excel and cannot add it from the COM Add-ins. Checking off the box will do nothing.
Cause
IBM Framework for Office is disabled.
Resolving The Problem
We need to check if the COM Add-in is disabled so in the Office Add-ins window (under File->Options->Add-ins), click on the drop down menu to manage the "Disable Items" and click "GO". The "IBM Framework for Office" COM Add-in will show in the disabled items list.
Steps to enable and activate:
- Select the COM Add-in from the list.
- Click on "Enable".
- In the Add-ins window, click on manage and the drop down to select "COM Add-ins".
- Click "Go".
- Make sure the "IBM Framework for Office" COM Add-box is checked.
- Click "Ok".
- The add-in should be available to use in Excel.
- Relaunch a new Excel session.
- IBM Planning Analytics ribbon appears again in Excel.
Document Location
Worldwide
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSD29G","label":"IBM Planning Analytics"},"Component":"","Platform":[{"code":"PF033","label":"Windows"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
05 February 2020
UID
ibm11420467