By default the Excel Solver tool is not shown in the Excel ribbon or toolbar. In order to use this tool, it must be loaded.
To add Excel Solver to the Excel ribbon:
- Click File
- Click Options
- Click Add-Ins on the left hand menu
- At the bottom of the window select “Excel Add-Ins” from the drop down menu and click Go…
- Check the box next to “Solver Add-in” and click ok
Now the Excel Solver add-in is enabled and available to use on the Data tab.