If Excel doesn’t show the Solver command

This article is part of my series: Excel Solver Guide (Easy and Step by Step).

You can access Solver by choosing Data ➪ Analysis ➪ Solver. Sometimes it may happen that this command isn’t available, you have to install the Solver add-in using the following steps:

  1. Choose File ➪ Options. The Excel Options dialog box appears.
  2. Select the Add-Ins tab.
  3. At the bottom of the Excel Options dialog box, select Excel Add-Ins from the Manage drop-down list and then click Go. The Add-Ins dialog box appears.
  4. Place a checkmark next to Solver Add-In, and then click OK.

After performing these steps, the Solver add-in loads whenever you start Excel.

Happy Excelling 🙂

Kawser

Hello! Welcome to my Excel blog! It took me some time to be a fan of Excel. But now I am a die-hard fan of MS Excel. I learn new ways of doing things with Excel and share them here. Not only how-to guide on Excel, but you will get also topics on Finance, Statistics, Data Analysis, and BI. Stay tuned! You can checkout my courses at Udemy: https://www.udemy.com/user/exceldemy/

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo