How to Install the Data Analysis ToolPak for PC & Mac

Written by

Editorial Team

Reviewed by

Steve Rynearson

Last updated on June 26, 2023

This tutorial demonstrates how to install the Data Analysis ToolPak Excel add-in for Mac and PC.

For PC Users

  1. In the Ribbon, go to File > Options.

FileOptions

  1. In the Options dialog box, at the bottom of the list to the left, click Add-ins.
    Then, where it says Manage at the bottom, choose Excel Add-ins from the drop down. Click Go.

Addins-options

  1. A pop-up window appears. Tick Analysis ToolPak and click OK.

addins-check-addin

  1. Now, access the Data Analysis command on the Data tab.

addins data analysis

Note: If Analysis ToolPak does not appear as one of the available add-ins (in Step 3), then you may need to install it. To do this, you would need to run the setup program for Microsoft Office and then choose the Change option to install the add-in. Once you have installed it, you can restart Excel and it should be available to use.

For Mac Users

  1. In the Menu, go to Tools > Add-ins.

mac-users-tools

  1. A window pops up. Tick Analysis ToolPak.
    If Analysis ToolPak does not appear as one of the available add-ins, then click Browse to locate it. Click Yes to install.

mac users add ins

  1. Now, access the Data Analysis command from the Data tab.

mac users access data analysis

Use the Data Analysis ToolPak for:

AI Formula Generator

Try for Free

See all How-To Articles