Feb 15 2017
02:40 PM
- last edited on
Jul 12 2019
10:42 AM
by
TechCommunityAP
Feb 15 2017
02:40 PM
- last edited on
Jul 12 2019
10:42 AM
by
TechCommunityAP
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?
Feb 18 2017 07:46 PM
I reappeared today. I do not understand.
Feb 26 2017 11:26 AM
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?
Feb 26 2017 11:28 AM
Jun 06 2017 11:27 AM
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?
Sep 16 2017 07:15 PM
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.
Feb 20 2018 12:14 PM
Is there an answer to this question? Where do you see Analysis Toolpalk in office 2016?
Jan 13 2020 04:11 PM
Jan 28 2020 12:53 AM
Same problem here. Any assistance on this would be fantastic.
Apr 03 2021 02:41 PM
if you have checked the add-in under OPTIONS and the toolpak is still not showing. try the step below. it worked for me
Feb 13 2022 03:33 PM
This happened to me, and I just fixed it. Here is how I did it:
Go to File>Options>Add ins. On the Add Ins page, at the bottom, it says Manage: Excel Add Ins Go. See my picture.
Click Go. A new box pops up. Make sure Analysis TooPak is checked. One I checked it, it reappeared.
Feb 13 2022 03:52 PM