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:

  1. Open File Tab and access options from bottom of left side menu.
  2. In options window, select Add-Ins from bottom of left side menu.
  3. Locate and select Solver Add-in inside Add-Ins window.Enable Solver in Excel
  4. 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.

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.