Forum Discussion

Erin1220's avatar
Erin1220
Copper Contributor
Sep 08, 2023

Excel add ins

Hello,

 

I am trying to add load the analysis toolpak in excel but I can't figure out how to add that and I can't seem to search for anything new. I follow the steps my teacher assigned but it isn't helping.

excel
    • Dunni500's avatar
      Dunni500
      Copper Contributor
      Sep 09, 2023
      Hello Hans,

      I am also having similar challenge. I need to use the Analysis Toolpak on MacOS but the function is not available in my excel. Are you able to help
      • HansVogelaar's avatar
        HansVogelaar
        MVP
        Sep 09, 2023

        Dunni500 

        For the desktop version of Excel for Mac, Load the Analysis ToolPak in Excel suggests:

         

        1. Click the Tools menu, and then click Excel Add-ins.

        2. In the Add-Ins available box, select the Analysis ToolPak check box, and then click OK.

          1. If Analysis ToolPak is not listed in the Add-Ins available box, click Browse to locate it.

          2. If you get a prompt that the Analysis ToolPak is not currently installed on your computer, click Yes to install it.

          3. Quit and restart Excel.

            Now the Data Analysis command is available on the Data tab.

         

Resources