Forum Discussion
TaquyiaC
Jul 14, 2024Copper Contributor
School assignment
I'm supposed to load a analysis toolpak on to my Excel. I don't know if I am doing something wrong. Please help me figure out if I have loaded it or what I am doing wrong.
Desperately
Taquyia Carter
1 Reply
Analysis ToolPak is for the desktop version of Excel for Windows and Mac. It does not work in Excel Online.
For example in Excel for Windows:
- Select File > Options.
- Select Add-ins. You should see something similar to this:
- As you can see, Analysis ToolPak is currently listed under 'Inactive Application Add-ins' on my PC.
- To activate it, click on Go... near the bottom of the dialog:
- Tick the check box for 'Analysis ToolPak', then click OK.
- You should now have new group on the right-hand side of the Data tab of the ribbon, Analysis, with one item: Data Analysis. Click that to start Analysis ToolPak.