How to find and install Data Analysis ToolPak or Solver for Excel for Mac Summary The Data Analysis ToolPak and Solver add-ins are not available in all Microsoft Excel for Mac versions. The following table shows which Excel for Mac versions include these add-ons. Version Data Analysis ToolPak included?
Solver included? Excel 2016 for Mac Yes Yes Excel for Mac 2011 No. Yes, starting with Excel for Mac 2011, Service Pack 1 (version 14.1.0) Excel for Mac 2008 No.
No Where to find Data Analysis ToolPak and Solver If the add-ins are available in the Excel for Mac installation that you are using, follow these steps to locate them:. Start Excel for Mac. Click Tools, and then click Add-Ins.
Solver Add In Excel Mac 2011
Click the Data Analysis ToolPak or Solver option to enable it. Then, click OK. Locate Data Analysis ToolPak or Solver on the Data tab.
How to Use Solver in Microsoft Excel. This wikiHow teaches you how to use Microsoft Excel's Solver tool, which allows you to alter different variables in a spreadsheet in order to achieve a desired solution. On a Mac, click Excel Add-ins in the Tools menu. Enable Solver in the 'Add-ins' section of your Excel preferences if necessary.