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:
- Choose File ➪ Options. The Excel Options dialog box appears.
- Select the Add-Ins tab.
- 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.
- 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 🙂