Solver Add-in Run-time Error 53

Issue/Question

When using the Solver Add-in in Excel, I receive error:

Run-time Error '53' 

File Not Found: Solver32.dll

Environment

• Windows
  • Microsoft Excel 2016
    • Solver Add-in

Resolution

1. Close Microsoft Excel completely.
2. Open Excel.
3. Open a Blank Workbook.
4. Click the Data tab on the Ribbon.
5. Launch Solver.
6. Make sure By Changing Variable Cells: is the same as Set Objective.
7. Click Solve.
8. Close the Solver Results dialog box.
9. Do not close the empty workbook.
10. Open the worksheet you want to run Solver in.
11. Launch Solver.