Enable Solver in Excel
This post details how to enable solver in Excel. Solver is an add-in for Excel that solves optimization problems for you. All you need to do is to setup the problem and select show solver target and variable cells. With some additional adjustments, solver will make iterative calculations and present you with an optimum solution.
For more information about solver: Excel Solver Add-in
An example application of solver for a real life decision supper scenario: Excel Solver Example
To enable solver in Excel, follow these easy steps:
- Open File Tab and access options from bottom of left side menu.
- In options window, select Add-Ins from bottom of left side menu.
- Locate and select Solver Add-in inside Add-Ins window.
- Click ok (If a small window opens with add-ins, put a tick near Solver and click ok).
Now that solver is enabled, you can find it under DATA tab towards the end of ribbon.