3326669 - Excel opens with Analysis for Office enabled, even when LoadBehavior is set to 0

When using Analysis for Office (AO) with LoadBehavior set to 0, Excel opens without AO by default. When AO is running, opening separate Excel Window after that, AO is also enabled there.

SAP Analysis for Microsoft Office All versions

1. Set LoadBehavior to 0 in the registry: HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins\SapExcelAddIn.
2. Start AO either from the start menu "Analysis for Microsoft Excel" or with BiOfficelauncher.exe or enable it manually in an Excel session in
3. File/Options/Add-ins.
4. Start regular Excel.
5. Observe AO is enabled in this second Excel window.

A new Excel session is always a new window. But not every new Excel window is a new session.
In this case Excel is not using a new session when after AO is already running.

If AO is opened once, Excel must be forced to a new session to not have AO.

1. Go to regedit: HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Excel\Options
2. Create a new DWORD value: DisableMergeInstance
3. set the value to 1.

SAP Help portal: Configuration of the loadbehavior setting from the AO Administrator Guide

Analysis, Office, Excel, session, window, separate, loadbehavior, normal, regular, without, disabled , KBA , BI-RA-AO-XLA , Excel Addin , Problem