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