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

What is Microsoft Solver Foundation?

It is a set of tools to work on mathematical simulation, optimization and modelling. It uses the managed execution and common language runtime (CLR). This means you can use any of the CLR languages including VB, Visual C++, Visual C#, Visual F#, and IronPython.
Of course you can also use ASP.NET and Silverlight in your mathematical operations.

Mathematical Solver Foundation APIs

• Can run remotely as a service within IIS and ASP.NET
• Can run in Excel as an add-in
• Integrate with other .NET Framework apps
• Embed as DSL within CLR languages
• Embed as a CLR compliant module.

Review this link for more:

https://msdn.microsoft.com/en-us/library/ff524497(v=vs.93).aspx