Troubleshooting
Problem
Since Planning Analytics for Excel 2.0.65, we just need to double-click an XLL file to open the add-in: no installation is needed anymore.
However, in previous versions, a default workbook was automatically opened: in newer versions, no default workbook is displayed anymore at startup.
Cause
Excel defect.
Resolving The Problem
This behavior is due to a known Microsoft Excel defect:
Office 365 does not open blank workbook after startup if ExcelDNA Addin is active #254
An easy solution, to work around this defect, is to create a blank "Book1.xlsm" workbook and save it in the XLSTART folder.
This folder can be found in one of these locations:
C:\Program Files\Microsoft Office\root\Office16\XLSTART
C:\Users\<user>\AppData\Roaming\Microsoft\Excel\XLSTART
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":"SSCTEW","label":"IBM Planning Analytics Local"},"ARM Category":[{"code":"a8m50000000KzJ4AAK","label":"Planning Analytics For Microsoft Excel"},{"code":"a8m0z000000blfjAAA","label":"Troubleshooting"}],"ARM Case Number":"","Platform":[{"code":"PF033","label":"Windows"}],"Version":"All Versions"}]
Was this topic helpful?
Document Information
Modified date:
04 February 2022
UID
ibm16553868