How to Activate the Analysis for Office Add-In
There is some situations where you have to manually activate the Analysis for Office Add-In.
You cannot find the Analysis Add-In tab in your MS Excel or MS Powerpoint.
You try to launch Analysis for Office and you are getting some errors like the messages below:
- “Unable to launch Analysis Add-in”
- “The launcher was not able to connect Analysis Add-In. Make sure that Analysis Add-In is not disabled by Office Application”
In these cases, Analysis Add-In may have been disabled by the Microsoft application after some crash. So you have to re-enable the Analysis Add-In in MS Excel or MS PowerPoint. This is very simple to solve and this post will show you how to do it.
1 – Open Excel Options.
2 – Click on “Add-Ins” tab and select “Disabled Items” in Manage box. Then click “Go”.
3 – If the Analysis Office Add-In is listed here select it and click on Enable.
4 – If Analysis Add-In is not listed, like in the screenshot above, go back to Step #2 and select “COM AddIn” in the Manage box. Then click “Go”.
5 – Make sure to have the Analysis Add-In checked and click “Ok”
You can also check the SAP note 1672606 and the AO Admin Guide (Chapter 9 – Troubleshooting).
SAP Active Global Support
Also check Analysis for Office’s blog: http://scn.sap.com/people/diego.ferrary/blog
For more Analysis for Office tool please check:
This is very helpful information...thanks for posting.
Hi, Analysis for Office is add-in of BI installation or BO client tool?
There is the client version (add-in for MS Excel) and the BIP ADD-ON which is installed on BI platform for scheduling of Analysis Workbooks.
You can find more details by visiting the link below:
SAP BusinessObjects Analysis, edition for Microsoft Office 2.1 SP1 – SAP Help Portal Page
Thanks Filipe. Can you please clarify one more doubt. Does it required to purchase new licence?
For questions related to sales and licenses, I recommend to contact SAP Account Executive or contact SAP via www.sap.com.
If you have Excel open, you can go to the Developer tab. There is a COM Add-ins icon there where you can check and enable Analysis.
This does not work anymore with the latest versions (2.1 SP2). If a user deactivates the Add In after a crash it is not possible to reactivate it. Direct start via SAP BI\AO is working but not the autostart with Excel or reactivating the Add In in Excel.
Can you confirm that the LoadBehavior of Analysis for Office in this case is set to 3 according to chapter 5.3 of Administrator's Guide available in http://help.sap.com/boao?
Also, after a crash in Excel, did you check if Analysis is not listed in the disabled items list according to the screenshots of this post?
Thank you for your fast reply. Yes the Load behavior setting is ok.
But you are right with disabled items. I think in past normaly it was enough the simply activate the checkbox again. But after reaktivation it works on the test machine. If this is the solution for all other pcs it's ok for me (currently some users are not available - I will test it on their machines as fast as possible - due to the crash bug which is discussed here (A Office 2.1 SP2 - exiting Excel 2010 ends in error) we have several users running into this problem..
Glad to hear that it worked for you 🙂
From my experience, after a crash in Excel or if the user manually choose to disable the add-in, it can only be activated again by going to "disabled items". And this is also valid for old versions of Analysis for Office as this is MS Excel's behavior.
However, maybe there are specific cases where it is possible to just enable the add-in again under "COM Add-ins".
I would recommend to always check the "disabled items" in cases like this.
This is also mentioned in SAP note 1672606.
Everytime I open my excel, i have to do these steps you showed.
Is it normal? Or how can i change the LoadBehavior to "Load at Startup", as you have in your last image?
You can change the Load Behavior of Analysis for Office via registry setting in client machine.
For AO 1.4 version, refer to chapter 4.2 of the Admin Guide available in http://help.sap.com/boao14
For AO 2.1 version, refer to chapter 5.3 of the Admin Guide available in http://help.sap.com/boao
The setting is "LoadBehavior" and if you want that AO activate together with Excel everytime, you can set the value "3".
Thank you very much for your reply. I've just correct it to value "3".
Concerning the load behavior:
In the admin documentation "SAP BusinessObjects Analysis, edition for 2.1 SP2 - 2015-09-18" site 38 is written:
"After installation, the default value is 0. This means that the Analysis Add-In is disabled and is not activated automatically when Microsoft Excel or PowerPoint is started."
But after installation of Version 220.127.116.11735,
Anylsis for Excel is startet with "...BiOfficeLauncher.exe" /app XLS /lb 3"
"/lb 3" means, that the Load Behavior is always switched back to 3.
I would prefer 0 as default, as it is written in the documentation.
Their is a permanent solution available to this given by SAP in below URL:
The 'Analysis ToolPak' is an add-in and can be used to apply complex data analysis with the good features, if you are expecting any issue in configuration and Analysis Add-In Launcher in the shortcut and in the registry then take help from the following link MS Office 365 Support, here is lot possibility that you can get the easy solutions.
Many thanks Filipe for your sharing! Only here I found a solution how to activate an Analysis add-in in Excel 2013.