Enable Solvertable In Excel

| Posted on by

  • To enable Solver, go to FILE Options Add-Ins. Then click Solver and press Go Check off all of the boxes and press OK. Now, Solver should be under the DATA tab, in the Analyze group. Solving a Single Equation For this example, we are going to solve the sample problem mentioned above of x2+3x-22=5.
  • Is your add-in missing? Learn how to re-enable it with this step-by-step tutorialExcel Add-ins can get disabled when Excel crashes. There is a Disabled Ite.

Now, select the cell into which you want to add a drop-down list and click the “Data” tab. In the Data Tools section of the Data tab, click the “Data Validation” button. The Data Validation dialog box displays. On the Settings tab, select “List” from the Allow drop-down list (see, drop-down lists are everywhere!).

Excel has a really powerful tool that allows you to conduct optimization, solve systems of simultaneous equations, and perform complex multi-variable regression or non-linear regression. This tool is called the Excel Solver Add In. And although it comes with every purchase of Excel it has to be enabled in your installation before you can use it.

The number of steps required to enable the Solver Add-In is determined by whether or not you have already enabled the Developer Tab. If you are working with a fresh install of Excel or have never enabled the Developer Tab start here. Otherwise, skip down to Enabling the Excel Solver Add-In.

To display the Developer Tab in the ribbon go to File>Options.

[Note: Want to learn even more about advanced Excel techniques? Watch my free training just for engineers. In the three-part video series I'll show you how to easily solve engineering challenges in Excel. Click here to get started.]

In the window that opens, select Customize Ribbon.

Next, select the checkbox next to Developer in the List Box on the right side.

Now the Developer tab will show up as the last tab in the ribbon, on the far right:

The Solver Add-In is enabled through the Developer tab.

Enable

First navigate to the Developer tab and select Excel Add-Ins.

Enable Solver Table In Excel Formula

[Note: Want to learn even more about advanced Excel techniques? Watch my free training just for engineers. In the three-part video series I'll show you how to easily solve engineering challenges in Excel. Click here to get started.]

From the list of Add-Ins that appears, select the Solver Add-In and Click OK.

Once enabled, Solver is accessed via the Data Tab.

If you don’t like navigating to the Data tab every time you want to use Solver, you can always add a shortcut to the quick-access toolbar. To do this, right-click on Solver (in the Data tab) and select “Add to Quick Access Toolbar”.

A link is added above the ribbon next to Save, Undo, Redo, and any other commands you’ve already added.

Enable Solver Table In Excel Spreadsheet

Clicking on the shortcut opens the Solver window, just as you’d expect.


Enable Solver Table In Excel Using

That is how you install the Excel Solver Add In with just a few easy steps. With this add-in enabled, you will be able set up design optimizations and other complex engineering calculations.

Enable Solver Table In Excel Shortcut

[Note: Want to learn even more about advanced Excel techniques? Watch my free training just for engineers. In the three-part video series I'll show you how to easily solve engineering challenges in Excel. Click here to get started.]