Load the Analysis ToolPak in Excel 2016 for Mac

The Analysis ToolPak is a Microsoft Excel add-in that is available when you install Excel. To use it, however, you need to load it first.

Note: It is not necessary to download the ToolPak. It comes with Excel when you install it on your Mac.

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

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

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

    • If you get prompted 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.

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!