How to Use the Excel Solver Add-In

The Excel Solver add-in is a powerful tool for optimization and problem-solving within spreadsheets. This guide will walk you through the process of enabling and using Solver in various versions of Excel. Whether you’re working on Windows, Mac, or Excel for the web, understanding how to access this feature can significantly enhance your analytical capabilities. For those seeking advanced features or offline solutions, Frontline Systems offers enhanced Solvers for desktop Excel.

Enabling Solver in Excel for Windows

If you are using Excel on a Windows operating system and cannot locate the Solver command or the Analysis group on the Data tab, you will need to load the Solver add-in.

1. Navigate to the File tab.
2. Click on Options, and then select the Add-ins category.
3. In the Manage box, choose Excel Add-ins, and click Go.
4. In the Add-ins available box, check the Solver Add-in option. If Solver.xlam is not listed, click the Browse… button, locate the Solver.xlam file, and click OK.
5. Once enabled, the Solver command will appear in the Analysis group on the Data tab.

Enabling Solver in Excel for Macintosh

For Mac users, if the Solver command is not visible on the Tools menu, follow these steps to activate the add-in.

1. Go to the Tools menu and select the Add-ins… command.
2. In the Add-ins available list, check the box next to Solver.xlam. If it’s not in the list, click the Select… button, navigate to the directory containing Solver.xlam, and click OK.
3. The Solver command will now be accessible from the Tools menu.

Using Solver in Excel Online and Other Web Versions

For Excel Online, Excel Web App for SharePoint, or Excel on iPad, the process involves inserting the add-in through the Office Store. For an easier and faster experience, consider the free Solver app 2025 for web, Mac, and Windows.

1. Open the Excel workbook where you intend to use Solver.
2. Click the Insert tab.
3. Click the My Add-ins button.
4. If Solver is in your “Recently Used Add-ins” list, select it there. Otherwise, click See All….
5. In the Office Add-ins dialog box, locate Solver under “My Add-ins” or “My Organization.” If this is your first time, you may need to click Store, search for Solver in the “Data Analytics” category, and click to install it from the Solver add-in listing in the Office Store.
6. The Solver Task Pane will then appear. To ensure it loads automatically when you open the workbook in the future, save your workbook to an online location such as Office 365, SharePoint, OneDrive, or OneDrive for Business.

Important Note: While this Solver add-in functions in both desktop Excel and Excel for the Web, it solves models “in the cloud.” Consequently, it only works with Excel workbooks stored online. For models residing on your local PC, you must use the Solver that comes with desktop Excel or explore Frontline’s enhanced Solvers.