Forum Discussion
What happened to Analysis Toolpak?
I am used to seeing Analysis Toolpak in the top right corner of the Data tab in Excel. It has disappeared. It is loaded according to the Options section in File. How can I get it back?
I also have the same problem
Am assuming you are using Excel 2016.
Anyway, the ATP (Analysis Tool Pack) can be enabled by the following steps:
File>Options>Add-ins........."Manage: Excel Add-ins"......... Click the : "Go" Button and you will see the ATP in a list of Add-ins options not loaded by default.
Once the ATP check box is ticked, you should have your ATP in the Data tab as usual.
Anyway, the ATP (Analysis Tool Pack) can be enabled by the following steps:
File>Options>Add-ins........."Manage: Excel Add-ins"......... Click the : "Go" Button and you will see the ATP in a list of Add-ins options not loaded by default.
Once the ATP check box is ticked, you should have your ATP in the Data tab as usual.
