Sep 22, 2017 - How to find and install Data Analysis ToolPak or Solver for Excel for Mac. The following table shows which Excel for Mac versions include. I'm distributing an Excel file with a Solver model. In order to avoid Reference problems for certain users of Excel 2007, I'm not enabling the refence in the VBA editor, but modifying the syntax as described in this post.
When you install Microsoft Excel, you have a choice to also install some of Excel's add-ins, such as the Solver tool. These add-ins are stored in Excel but are not available from the menus until you activate them. Before trying to locate your installation disc, try activating the add-in you need through the Excel Options screen. If the add-in does not show in the Manage drop-down list, you will need your Excel installation disc and can easily install the add-ins you need by following the on-screen instructions.
Step 1
Click the Microsoft office button at the top left, and then click the 'Excel Options' button.
Step 2
Step 3
Verify that 'Excel Add-ins' is selected in the Manage drop-down list and click 'Go.'
Step 4
Select the check box that corresponds with the add-in you need and click 'OK.'
Follow the onscreen instructions to install the add-in.
Video of the Day
Brought to you by Techwalla
- 'Excel for Accountants, 2nd edition'; Conrad Carlberg; February 2011
- Ablestock.com/AbleStock.com/Getty Images