Want to get more from Excel, Solver and Analytics?
Attend a LIVE WEBINAR about Analytic Solver with a real expert, Dr. Sima Maleki.

<h2>How To Use The Excel Solver Add In</h2>

<p>In <font style="font-weight: bold;">Excel for Windows</font>, if you don&#39;t see the Solver command or the Analysis group on the Data tab, you need to load the Solver add-in.</p>

<p style="margin-top: 0pt; margin-left: 36pt;">1. Click the <font style="font-weight: bold;">File tab</font>, click <font style="font-weight: bold;">Options</font>, and then click the <font style="font-weight: bold;">Add-ins</font> category.</p>

<p style="margin-left: 36pt;">2. In the <font style="font-weight: bold;">Manage</font> box, click <font style="font-weight: bold;">Excel Add-ins</font>, and then click <font style="font-weight: bold;">Go</font>.</p>

<p style="margin-left: 36pt;">3. In the <font style="font-weight: bold;">Add-ins available</font> box, select the <font style="font-weight: bold;">Solver Add-in</font> check box.&nbsp; If you don&#39;t see this name in the list, click the <strong>Browse...</strong> button and navigate to the folder containing Solver.xlam.&nbsp; Then click <font style="font-weight: bold;">OK</font>.</p>

<p style="margin-left: 36pt;">4. Now on the <strong>Data </strong>tab, in the <strong>Analysis </strong>group, you should see the <strong>Solver </strong>command.</p>

<p>In <font style="font-weight: bold;">Excel for Macintosh</font>, if you don&#39;t see the Solver command on the Tools menu, you need to load the Solver add-in.</p>

<p style="margin-top: 0pt; margin-left: 36pt;">1. Click the <font style="font-weight: bold;">Tools</font> menu, then click the <font style="font-weight: bold;">Add-ins</font> command.</p>

<p style="margin-left: 36pt;">2. In the <font style="font-weight: bold;">Add-ins available</font> box, select the <font style="font-weight: bold;">Solver.xlam</font> check box.&nbsp; If you don&#39;t see this name in the list, click the <strong>Select...</strong> button and navigate to the folder containing Solver.xlam.&nbsp; Then click <font style="font-weight: bold;">OK</font>.</p>

<p style="margin-left: 36pt;">3. Now on the <strong>Tools </strong>menu, you should see the <strong>Solver </strong>command.</p>

<p>In <font style="font-weight: bold;">Excel Online</font> for Office 365, <font style="font-weight: bold;">Excel Web App</font> for SharePoint, or <font style="font-weight: bold;">Excel on iPad</font>, use the <a href="/solver-app-help-and-support">Solver add-in</a>.&nbsp; If you don&#39;t see the Solver Task Pane in your worksheet, you need to <font style="font-weight: bold;">insert</font> the Solver add-in: Follow the steps in <a href="http://office.microsoft.com/en-us/store/office-store-faq-HA102900784.aspx" target="_blank">Microsoft Office Support</a> on <a href="http://office.microsoft.com/en-us/excel-help/get-an-app-for-excel-HA1028... target="_blank">How to get an Office Add-in for Excel</a>.</p>

<p style="margin-top: 0pt; margin-left: 36pt;">1. Open the workbook where you want to use Solver.&nbsp; Click the <font style="font-weight: bold;">Insert </font>tab, then click the <font style="font-weight: bold;">My Add-ins</font> button.</p>

<p style="margin-left: 36pt;">2. <font style="font-weight: bold;">Solver </font>appears in the <font style="font-weight: bold;">Recently Used Add-ins </font>dropdown list, select it there, and skip to step 4.</p>

<p style="margin-left: 36pt;">3. Select <font style="font-weight: bold;">See All...</font> from the dropdown menu.&nbsp; In the <font style="font-weight: bold;">Office Add-ins</font> dialog, find and select Solver under<br />
<font style="font-weight: bold;">My Add-ins</font> or <font style="font-weight: bold;">My Organization</font>.<br />
If this is your first time using the Solver add-in, click <font style="font-weight: bold;">Store</font>, and look in the Data Analytics category.&nbsp; Click to see the <a href="https://appsource.microsoft.com/en-us/product/office/WA104100404?tab=Ove... target="_blank">Solver add-in listing</a> in the Office Store.</p>

<p style="margin-left: 36pt;">4. The Solver Task Pane should appear. Click <font style="font-weight: bold;">File Save As</font>, and save to your Office 365 or SharePoint document library, or OneDrive or OneDrive for Business folder.</p>

<p style="margin-left: 36pt;">5. Now when you open your workbook, the Solver Task Pane should appear automatically.</p>

<p><em>NOTE</em>: Although the Solver add-in can be used in both desktop Excel and Excel for the Web, because your model is solved &quot;in the cloud,&quot; this Solver add-in works only with <font style="font-weight: bold;">Excel workbooks that are stored online</font>.&nbsp; If you want to solve a workbook model that is stored on your local PC, use the Solver included with desktop Excel, or one of Frontline&#39;s <a href="/products-overview">enhanced Solvers</a> for desktop Excel.</p>