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?
if you have checked the add-in under OPTIONS and the toolpak is still not showing. try the step below. it worked for me
Same problem. What the heck?
Same problem here. Any assistance on this would be fantastic.
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 selected the ATP and clicked Go. Then I got a box with ATP box selected. I clicked OK, but the software does not load under the Data Tab? What can I do?
I reappeared today. I do not understand.
- 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.
