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 🙂

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 here. Not only how to guide on Excel, but you will get also topics on Finance, Statistics, Data Analysis, and BI. Stay tuned!

We will be happy to hear your thoughts

      Leave a reply