Solver is built into Excel but turned off by default

Solver is a tool inside Excel that finds the best answer to a problem by testing different numbers. It comes with Excel but you have to switch it on first — it does not appear in your ribbon until you tell Excel to show it. Once it is on, you can use it to answer questions like "what sales price gets me exactly $50,000 profit" or "what combination of ingredients costs the least while hitting my nutrition targets."

Solver works differently from a regular formula. A formula calculates a result based on numbers you put in. Solver works backward: you tell it what result you want, and it figures out what numbers need to be true to get there. This is why it lives in a separate tool instead of being a standard function.

The steps to turn it on differ slightly between Windows and Mac, but the idea is the same: you go to your add-ins settings and check the box next to Solver.

Key Takeaways

  • Solver is included with Excel but hidden by default, and you must enable it through the Add-ins menu before you can use it.
  • On Windows, go to File > Options > Add-ins, select Excel Add-ins from the dropdown, click Go, and check the Solver box.
  • On Mac, go to Tools > Excel Add-ins, find Solver in the list, and click OK to turn it on.
  • Once enabled, Solver appears on the Data tab in your ribbon and lets you set a target cell, change cells, and constraints to find the best answer.

Enabling Solver on Windows

Open Excel and go to the File menu in the top left. Click Options at the bottom of the menu. A window titled "Excel Options" will open.

On the left side of this window, click Add-ins. At the bottom of the window, you will see a dropdown that says "Manage:" with "Excel Add-ins" already selected. Click the Go button next to it. A smaller window titled "Add-ins" will pop up with a list of available add-ins.

Look for Solver Add-in in the list. Click the checkbox next to it to put a checkmark there. Then click OK. The window closes and you are done. Solver is now on.

To confirm it worked, click the Data tab in your ribbon at the top of the spreadsheet. On the right side of the Data tab, you should see a button labeled Solver. If you see it, the add-in is active.

Enabling Solver on Mac

Open Excel and click the Tools menu at the top of your screen. From the dropdown, click Excel Add-ins. A window will open showing a list of available add-ins.

Find Solver in the list and click it once to select it. Then click the OK button. The window closes and Solver is now enabled on your Mac.

To verify it is on, click the Data tab in your ribbon. Look toward the right side of the ribbon — you should see a Solver button there. If it appears, the add-in is working.

What to do if Solver does not appear after you enable it

If you turned on Solver but do not see it on the Data tab, close Excel completely and open it again. Sometimes Excel needs to restart before a newly enabled add-in shows up in the ribbon.

If Solver still does not appear after restarting, check that you actually clicked the checkbox (or selected the item and clicked OK on Mac). Go back to the add-ins menu and look again — the checkbox should have a checkmark, or Solver should be highlighted in the list. If it is not checked or selected, repeat the steps above.

On Windows, if the Add-ins window is empty or Solver is not in the list, your Excel installation may be incomplete. You can repair Excel by going to File > Account > About Excel, then looking for an option to repair or reinstall. On Mac, try restarting your computer and opening Excel again.

How Solver works once it is turned on

After you enable Solver, you set up a spreadsheet with three things: a target cell (the result you want), changing cells (the numbers Solver is allowed to adjust), and constraints (the rules Solver must follow). Then you click the Solver button and tell it to find the answer.

For example, if you have a spreadsheet that calculates profit based on price and quantity sold, you could set the target cell to your profit formula, tell Solver to change the price cell, and add a constraint that price cannot go below cost. Solver will then test different prices until it finds the one that gives you the highest profit while staying above your cost floor.

Solver is most useful when the answer is not obvious or when there are many constraints to balance. For straightforward calculations, a regular formula or a data table is usually faster.

Troubleshooting Solver after it is enabled

If Solver opens but gives you an error when you try to run it, the most common cause is that your target cell does not contain a formula — it contains just a number. Solver needs a formula in the target cell so it can see how the result changes when the changing cells are adjusted. Make sure your target cell has a formula that references your changing cells, even indirectly.

Another common issue is that Solver cannot find a solution because the constraints are impossible to meet. For example, if you ask it to make profit equal $100,000 but your maximum possible revenue is $50,000, there is no answer. Solver will tell you it could not find a solution. In that case, loosen your constraints and try again.

Frequently Asked Questions

Does Solver come with all versions of Excel?

Solver comes with Excel for Windows (all versions) and Excel for Mac. It does not come with Excel Online or Excel for iPad. If you use Excel Online, you cannot use Solver — you would need to read the desktop version instead.

Will turning on Solver slow down my spreadsheet?

No. Enabling Solver does not affect your spreadsheet's speed or performance. It only runs when you click the Solver button and tell it to solve a problem. The rest of the time it sits inactive in your ribbon.

Can I use Solver on a spreadsheet someone else created?

Yes. As long as Solver is enabled on your copy of Excel, you can open anyone's spreadsheet and use Solver on it. The spreadsheet does not need to have Solver already set up — you set it up yourself when you open it.

What is the difference between Solver and Goal Seek?

Goal Seek is a simpler tool that changes one cell to reach a target in another cell. Solver is more powerful and can change multiple cells at once while following multiple rules. If you only need to adjust one number, Goal Seek is faster. If you have many variables and constraints, use Solver.