Troubleshooting
Problem
In Excel when use Planning Analytics for Excel on right click extension menu is missing
Symptom
missing Planning Analytics for Excel menu on right click
example of missing menu:
example of expected menu:
Cause
The problem might be caused by plugins conflict or Excel configuration file issue
Resolving The Problem
1)Disable all additional Excel plugins
2)Start Excel in Safe Mode
- Close Excel.
- Press Win + R, type excel /safe, and hit Enter.
- If the menu appears, a conflicting add-in might be causing the issue.
3)Stop Excel, delete excel right click menu configuration file Excel.xlb located under
C:\Users\<USER_DIRECTORY>\AppData\Local\Microsoft\Excel
Please notice that the file location depend from OS version
The file should be recreated after restart Excel.
For more information please check Excel - right click menu missing. - Microsoft Community
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSD29G","label":"IBM Planning Analytics"},"ARM Category":[{"code":"a8m50000000KzJ4AAK","label":"Planning Analytics-\u003EPlanning Analytics For Microsoft Excel"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":""}]
Was this topic helpful?
Document Information
Modified date:
27 May 2025
UID
ibm17234769