
You can also check the SAP note 1672606 and the AO Admin Guide (Chapter 9 – Troubleshooting). Then click “Go”.ĥ – Make sure to have the Analysis Add-In checked and click “Ok”

Then click “Go”.ģ – If the Analysis Office Add-In is listed here select it and click on Enable.Ĥ – 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.
#How to add analysis toolpak on excel how to#
This is very simple to solve and this post will show you how to do it.Ģ – Click on “Add-Ins” tab and select “Disabled Items” in Manage box. So you have to re-enable the Analysis Add-In in MS Excel or MS PowerPoint. In these cases, Analysis Add-In may have been disabled by the Microsoft application after some crash. Once enabled the Data Analysis ToolPak will be located in the the Data tab all the way to the right. The Add-Ins window will open, add a checkmark to the check box next to Analysis ToolPak, click OK. Make sure that Analysis Add-In is not disabled by Office Application” At the bottom of the window select Excel Add-ins from the drop-down to the right of Manage:, click Go to proceed.
