Install Solver in Excel: A Step-by-Step Setup Guide

To install Solver in Excel for Microsoft 365 on Windows, open File > Options > Add-ins, choose Excel Add-ins beside Manage, select Go, tick Solver Add-in, and choose OK. Solver is a built-in Excel add-in that helps find an optimal result by changing selected worksheet values while meeting your conditions. You do not normally need to download it separately; you do need the desktop version of Excel, because Solver cannot be run in Excel for the web.

What You’ll Need

The desktop Excel app for Windows, with a Microsoft 365 account or another supported desktop Excel installation.
A workbook open in Excel. You can enable Solver before you have a model ready, but a worksheet with a formula and cells that Solver can change is useful for checking that it opens.
Permission to enable Office add-ins. On a work or school device, an administrator may control add-in availability or Office installation options.
A working Office installation. Solver is included with Excel, so avoid downloading Solver files from unofficial websites.

Step-by-Step

Open the desktop Excel app. Start Excel for Windows and open a workbook, or create a blank one. Check that you are not working in Excel for the web in a browser: the web app can open and edit many workbooks, but it does not provide the desktop Solver add-in for running an optimization. If your file is open in a browser, use the option to open it in the desktop app, or launch Excel from your computer and open the file there.

If you have several Office apps installed, make sure you are using Excel rather than a spreadsheet viewer or another program. The instructions below use the Microsoft 365 Windows ribbon. Excel menus can look slightly different in other desktop releases, but the add-in is enabled through Excel’s add-in settings.
Open the Excel Add-ins settings. Select File at the upper left, then select Options near the bottom of the File screen. In the Excel Options window, choose Add-ins in the left-hand list. This page shows the add-ins Excel knows about and includes a Manage control near the bottom.

Find the Manage drop-down at the bottom of the window. Set it to Excel Add-ins, then select Go. This choice matters: the list for Excel Add-ins is different from the list for COM Add-ins. Solver is enabled through the Excel Add-ins list, so do not select COM Add-ins just because it appears nearby.
Find Solver in the Add-Ins dialog. The Add-Ins dialog displays available Excel add-ins with checkboxes. Look for Solver Add-in in the list. If it is shown, select its checkbox. If the checkbox is already selected, Solver may already be enabled; select OK to close the dialog and check the Data tab before changing anything else.

If Solver Add-in is not listed, do not search the web for a copy of solver.xlam or download a file from an unfamiliar site. Select Browse only if you already know the location of a Solver file that belongs to your trusted Office installation. Otherwise, continue to the troubleshooting section: Excel may need its installed features repaired, or your organization may manage which add-ins are available.
Enable the add-in and allow installation if prompted. With Solver Add-in checked, select OK. Excel may take a moment to load it. If Excel displays a prompt saying that the add-in is not currently installed and asks whether to install it, approve the prompt. Excel may need access to its Office installation files, and a work computer might ask for administrator approval.

Wait for the dialog to close rather than clicking through multiple times. Enabling the add-in adds Solver to Excel’s available commands; it does not change worksheet values or automatically optimize a workbook. If the dialog closes without an error, move on to the ribbon check.
Confirm that Solver is available. Select the Data tab. On the Windows ribbon, look for Solver in the Analysis group, usually toward the right side of the ribbon. If you can see the Solver command, the add-in is enabled. Select it once to confirm that the Solver Parameters dialog opens, then select Cancel if you are not ready to set up a model.

If the Data tab is narrow or the Excel window is small, a ribbon group or command may be compressed or hidden. Maximize the Excel window and inspect the Data tab again. The command’s position can differ with ribbon layout and window size, but it should be available from Data when the add-in has loaded.
Set up a small model if you want to test Solver. Solver needs a worksheet formula to evaluate and one or more cells it is allowed to change. In the Solver Parameters dialog, Set Objective identifies the formula cell; choose whether to maximize it, minimize it, or set it to a specific value. By Changing Variable Cells identifies the input cells Solver may adjust. Subject to the Constraints lets you set limits, such as requiring a value to be no less than zero.

For example, a planning sheet might calculate total profit in one formula cell, while separate cells contain quantities to produce. You could ask Solver to maximize the profit cell by changing the quantity cells, subject to available-material limits. This is an example of what Solver can do, not a requirement for installing it. You can cancel the dialog without running a model.

Common Mistakes

Looking for Solver in the wrong add-in list. The Windows Manage control offers different categories. Choose Excel Add-ins and then Go; Solver is not enabled by selecting COM Add-ins.
Expecting Solver to appear in Excel for the web. Installing or enabling the desktop add-in does not add a Solver command to the browser version. Open the workbook in desktop Excel to use Solver.
Assuming Solver is a separate download. For a standard Excel installation, the add-in is supplied with Office. Third-party download sites can provide outdated or unsafe files and are not needed for the normal setup.
Confusing installation with model setup. Enabling Solver only makes its command available. To solve a problem, the workbook still needs an objective formula, adjustable cells, and any relevant constraints.
Closing the Add-Ins dialog without selecting OK. Choose OK after checking Solver Add-in so Excel can load the selection. Merely ticking the box and closing the dialog with its close button may not apply the change.

Tips

Save your workbook before experimenting. Solver can change the values in its adjustable cells when you run it. Saving first gives you a straightforward way to return to the starting file if you do not want to keep the result.
Give your worksheet clear labels. Label the objective, decision cells, and resource limits. When you open Solver Parameters, clear labels make it easier to select the right cell ranges and understand what a result means.
Choose constraints that reflect the real problem. For instance, use nonnegative limits for quantities that cannot be below zero, and include capacity or budget limits where they apply. Solver can only respect conditions that you have actually specified.
Check that the objective is a formula. Solver optimizes the result calculated in the objective cell by changing the cells you specify. A fixed number in the objective cell does not describe a relationship that Solver can improve.
Know which app you are using. On a Windows desktop, use File > Options > Add-ins. On a Mac, use Tools > Excel Add-ins, select Solver Add-in, and confirm with OK. Ribbon and dialog details can differ on Mac. Excel for the web does not run this desktop add-in.
Keep the model understandable. Use a manageable number of changing cells and constraints while building the first version. Once the model gives a sensible result, add further details and check whether the result still meets the practical requirements.

Troubleshooting

Solver Add-in is missing from the list: Return to File > Options > Add-ins, verify that Manage is set to Excel Add-ins, and select Go. If it is still absent, close Excel and reopen it, then check again. If the add-in remains unavailable, use your organization’s Office support process or repair the Office installation through the available Windows or Microsoft 365 support options. On a managed computer, ask your administrator whether add-ins or Office features are restricted. Do not install an unverified add-in file as a workaround.

The box is checked, but Solver is not on the Data tab: Open the Add-Ins dialog again and confirm the checkmark remains selected, then choose OK. Close and restart Excel if the command still does not appear. Maximize the window and inspect the Data tab, since ribbon commands can be less visible in a compact layout. If you have multiple Excel installations, enable the add-in in the same desktop app where you are opening the workbook.

Excel asks for files or administrator permission: Approve the installation only through Excel’s own prompt and follow your organization’s process if elevated permission is required. If the prompt fails or you do not have permission, contact the person who manages Office on the device. Solver is supplied as part of Excel, so this is generally an Office setup or permissions issue rather than a reason to download a replacement.

The Solver button opens, but a model will not solve: Check the Solver Parameters fields. Confirm that Set Objective points to a cell containing a formula, that By Changing Variable Cells contains the intended inputs, and that the constraints use the correct cells and limits. Also check the worksheet for errors or unintended blank cells. Installation can be successful even when a particular model needs correction.

You are using a Mac or browser: On Mac, enable the add-in from Tools > Excel Add-ins and then look for Solver on the Data tab. If your interface differs, check the add-in options in your installed Excel version. In a browser, switch to the desktop Excel app; refreshing the browser will not make the desktop Solver command available there.

Frequently Asked Questions

Is Solver already included with Excel?
Yes. Solver is supplied as an Excel add-in, but it may need to be enabled before its command appears. For the standard Windows setup, use File > Options > Add-ins, choose Excel Add-ins, select Go, and check Solver Add-in.

Do I need to download Solver separately?
No, not for a standard desktop Excel installation. Excel provides the add-in. If it is unavailable in the Add-Ins list, check the Office installation or ask your administrator rather than downloading a file from an unofficial source.

Can I use Solver in Excel for the web?
No. Excel for the web does not run the desktop Solver add-in. Open the workbook in the desktop Excel application on Windows or Mac to access Solver.

Does enabling Solver change my workbook?
Enabling Solver makes its command available in Excel; it does not automatically run an optimization or alter your worksheet values. Values may change when you set up and run a Solver model, so save a copy before trying a model if you want to preserve the original state.

Do I have to enable Solver for every workbook?
Normally, you enable the add-in for the Excel desktop installation you are using, rather than installing it separately into each workbook. A different computer, user profile, or Excel installation may have its own add-in settings.

Where is Solver on a Mac?
In desktop Excel for Mac, open Tools > Excel Add-ins, select Solver Add-in, and confirm. Then check the Data tab for the Solver command. The Mac interface is not identical to the Windows ribbon, and Excel for the web does not provide the desktop add-in.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.