2780964 - How to force Excel to open in a new instance by default without Analysis for Office Add-in

When Analysis for Office is started, then regular Excel cannot be started without Analysis for Office Add-in.

SAP Analysis for Microsoft Office

3rd party behavior.

Analysis for Office settings

Please use the load behavior /lb 0 parameter in the registry and in the Analysis for Office shortcut at the same time, to avoid that the Analysis for Office is started when open a regular Excel.
See also instruction in the SAP Note: 2140349 - "How to set parameters of the launcher executable".

• /lb 0 parameter in the registry:

• /lb 0 parameter in Analysis for Office shortcut:

More about the parameters see:
http://help.sap.com/boaa
click on the "Administrator Guide"
Search for /lb 0
Search for /CreateProcess

The /CreateProcess parameter works only with Analysis for Office.

Similar parameter that works only with Microsof Excel is called DisableMergeInstance, see below how it works.

Microsoft settings

Set DisableMergeInstance to 1, see also the reference pages:

https://support.microsoft.com/en-us/kb/3165211
https://support.microsoft.com/en-us/kb/3115162

Results of the settings

Case1:

Set DisableMergeInstance 1 allows to open a regular Excel and Analysis for Office in parallel, both instances use separated memory.

Case2:

Set DisableMergeInstance 0 allows to open a regular Excel or Analysis for Office, but both are equal with or without Analysis for Office Add-in.

Overall information

Each new Excel session consume memory, which can influence the client PC or Citrix and Excel performance.

Analysis for Office, workbook, new instance, new session, regedit, plugin, LoadBehavior, /lb 3, /lb 2, BiOfficeLauncher.exe , KBA , BI-RA-AO-XLA , Excel Addin , How To