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:


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.


Click File | Options to open the Excel Options window.

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


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


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.


No comments: