Solver Add-in for Excel for Mac 2011 SP1 Installing Data Analysis & Solver Add-ins for Excel 2013 Resolved: Excel 2016 for Mac - Solver Add-in not allowing cell references to be picked. Follow these steps to load the Analysis ToolPak in Excel 2016 for Mac: Click the Tools menu, and then click Excel Add-ins. In the Add-Ins available box, select the Analysis ToolPak check box, and then click OK.
The Analysis ToolPak is an add-in program that adds advanced statistical functions to Excel, such as variance, correlation, frequency and sampling analysis. Although this program is loaded onto computers as part of an overall Microsoft Office installation, it is not immediately available in Excel, and you must manually load it from the application before you can use it.
Step 1
Open the worksheet in which you want to use the Analysis ToolPak, or create a new worksheet. Click the 'File' tab on the top menu and click 'Options.'
Step 2
Click 'Add-Ins' on the side menu in the Options window. Click 'Go' in the Manage area at the bottom of the main screen to open the Add-Ins menu.
Step 3
Check the box next to 'Analysis ToolPak' and click 'OK.' If you cannot see the ToolPak listed in the menu, select 'Browse' to find it. Click 'Yes' if a message asks if you want to install it onto your computer.
Click the 'Data' tab on your worksheet. If the ToolPak has been successfully added, you'll see a Data Analysis option in the Analysis group.
Tip
- You can also add Visual Basic functions to the Analysis ToolPak. To do this, select 'Analysis ToolPak - VBA' from the Add-Ins menu when you add the Analysis ToolPak.
Warnings
- These instructions are based on Excel 2013. The process to load the add-in onto previous versions of Excel may be different.
- The Analysis ToolPak cannot be added to a Windows RT PC.
Video of the Day
Excel Analysis Toolpak Office 365
How To Install Data Analysis Toolpak In Excel For Mac
- Jupiterimages/Photos.com/Getty Images