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?
Hi Steve,
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.
Stephen Maguire wrote: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 have the same problem as OP describes. I have gone to add the toolpak, but it is already added. (I also removed it and added it again.) That's not the problem. It used to show up under the data tab. Now the data tab looks different and there is no "analysis" section under which the toolpak would normally show up. How do I get the analysis toolpak back?
Please respond ASAP.
Is there an answer to this question? Where do you see Analysis Toolpalk in office 2016?
- I had the same problem today. It had vanished. I went to File Options Add ins selected Analysis Pack uniticked it it under Manage Add Ins. Then reversed the process and re-installed it. It has reappeared in the top rh corner of the Data drop down ribbon.
