How to Activate the Analysis for Office Add-In

Hi All,

There is some situations where you have to manually activate the Analysis for Office Add-In.

Situation #1:

You cannot find the Analysis Add-In tab in your MS Excel or MS Powerpoint.

Situation #2:

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).

Cheers,

Filipe Zeuch
SAP Active Global Support
**************************************
Also check Analysis for Office’s blog: https://scn.sap.com/people/diego.ferrary/blog

For more Analysis for Office tool please check:

https://help.sap.com/boao
https://scn.sap.com/community/businessobjects-analysis-ms-office
https://scn.sap.com/docs/DOC-7679
https://www.sap.com