Troubleshooting
Problem
Launching Excel with the Planning Analytics for Excel add-in enabled crashes Excel.
Symptom
If you attempt to load Excel without the add-in, it loads successfully.
Cause
Add-in conflict in the Registry could be the reason this happens.
Resolving The Problem
You need access to the Registry to perform the following steps. Make a backup of the Registry before you attempt to do the steps.
With Excel closed, Open the Registry Editor and navigate to:
Computer\HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0\Excel\Options
Once there, right click the "Options" folder and click delete. This will remove any other add-ins other than Planning Analytics for Excel as well. You will need to re-add the add-ins when you launch Excel. Launch Excel and test again by adding the Planning Analytics Add-in.
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSD29G","label":"IBM Planning Analytics"},"ARM Category":[{"code":"a8m50000000KzLAAA0","label":"Planning Analytics-\u003EPlanning Analytics For Microsoft Excel-\u003EInstall Configure and Upgrade"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]
Was this topic helpful?
Document Information
Modified date:
07 December 2022
UID
ibm16845934