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: https://scn.sap.com/people/diego.ferrary/blog
For more Analysis for Office tool please check: