Showing posts with label Solver. Show all posts
Showing posts with label Solver. Show all posts

Wednesday, August 12, 2015

How do you bring in Solver to Microsoft Excel?

Microsoft's Mathematical Solver Foundation APIs can run on Excel as an add-in.

Adding Solver to your Excel application is quite easy.

Presently I have Microsoft Excel 2013 which is a subscription (~$10/month) I have for Microsoft Office 365 Business shown here:


Office365.png

Launch a new Excel application from its shortcut. The Book1-Excel window will be open as shown. Note that the Data menu is highlighted here. If Solver is already added you should see it in this menu.

SolverAddIn_0.png

Click File | Options to open the Excel Options window.

Click Add-ins to open the Microsoft Add_ins as shown.


SolverAddin.png

Click on Solver Add-in and click OK to open this picklist Add-ins window.

SolverAddin_2.png

Place check mark for Solver Add-in  and click OK.

The Solver gets into the Data menu as shown. From where you can launch it.

SolverAddin_3.png