Symptom
When Analysis for Office is started, then regular Excel cannot be started without Analysis for Office Add-in.
Environment
SAP Analysis for Microsoft Office
Cause
3rd party behavior.
Resolution
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.
Keywords
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