Microsoft Office Tutorials and References
In Depth Information
ADDING EXCEL SOLVER TO THE EXCEL RIBBON
ADDING EXCEL SOLVER TO THE EXCEL RIBBON
Before you can use Excel Solver, you must determine whether it is installed in Excel. Start Excel and then
click the Data tab in the Ribbon. If you see a group on the right side named Analysis that contains Solver,
you do not need to install Solver (see Figure D-1).
FIGURE D-1
Analysis group with Solver installed
If the Analysis group or Solver is not shown on the Data tab of the Ribbon, do the following:
1. Click the File tab.
2. Click Options (see Figure D-2).
3. Click Add-Ins (see Figure D-3) to display the available add-ins in the right pane.
4. Click Go at the bottom of the right pane. The dialog box shown in Figure D-4 appears.
5. Click the Solver Add-in box as well as the Analysis ToolPak and Analysis ToolPak-VBA boxes.
(You will need the latter options in a subsequent case, so install them now with Solver.)
6. Click OK to close the window and return to the Ribbon. If you click the Data tab again, you
should see the Analysis group with Data Analysis and Solver on the right.
FIGURE D-2
Excel Options selection
 
Search JabSto ::




Custom Search