How to Download Solver in Excel | Load the Built-In Add-In

You don’t download Solver separately — it’s a free add-in already included with Excel. Loading it takes about 30 seconds through File > Options > Add-ins on Windows or Tools > Add-ins on Mac.

A common search for “download Solver” makes sense: most Excel tools come as standalone installers. But Microsoft built Solver directly into Office decades ago, and it ships with every desktop copy of Excel. The trick isn’t finding a download link — it’s knowing which menu to open and which checkbox to tick. Below are the exact steps for Windows, Mac, and web versions, plus what to do when the add-in doesn’t appear in the list.

What Exactly Is the Solver Add-In?

Solver is an optimization tool that finds the best value for a formula in one cell — subject to constraints you set on other cells. It’s useful for resource allocation, scheduling, financial modeling, and any “what’s the maximum/minimum” problem with limits. Microsoft includes it as an add-in program that must be loaded before it appears on the ribbon.

The add-in is available on Windows, macOS, Android, iOS, and Windows Mobile, but the loading instructions differ by platform. Desktop Excel uses the add-in loader; web and iPad versions use the Office Add-ins store instead.

How to Load Solver on Windows (The Standard Path)

This is the main method for Excel 2013 through Excel 365 on Windows. The add-in loads into the Data tab’s Analysis group.

1. Open Excel and go to File > Options.
2. In the left sidebar, click Add-ins.
3. At the bottom, next to Manage, select Excel Add-ins from the dropdown and click Go.
4. In the Add-Ins dialog, check Solver Add-in and click OK.

Solver now appears on the Data tab in the Analysis group. If you don’t see it immediately, close and reopen Excel.

The Solver button shows up as a small icon with a crystal-ball and grid symbol next to the Data Analysis button.

How to Load Solver on a Mac

The Mac path is different from Windows — don’t look for File > Options. Microsoft designed the Mac add-in loader to live under the Tools menu.

1. Open Excel for Mac.
2. Click Tools on the menu bar.
3. Select Add-ins from the dropdown.
4. In the Add-Ins dialog, check Solver.xlam (or simply Solver Add-in) and click OK.

After loading, Solver appears on the Tools menu itself — not on the Data tab. This is a common point of confusion for users switching from Windows.

You’ll see a new “Solver…” entry near the bottom of the Tools menu.

If Solver Is Missing From the Add-Ins List

Sometimes the add-in doesn’t show up in the list at all. This usually means Excel can’t find the Solver.xlam file in its default add-ins folder.

• On Windows: In the Add-Ins dialog, click Browse and navigate to the Solver.xlam file. It’s normally located inside the Office installation folder (e.g., C:\Program Files\Microsoft Office\root\Office16\Library\SOLVER). If prompted that the add-in is not installed, click Yes to install it from the Office source.
• On Mac: Use Tools > Add-ins, click Browse, and locate Solver.xlam. It is usually inside the Office application package under /Library/Application Support/Microsoft/Office365/User Content/Add-ins.

If the file genuinely isn’t on your system, you may need to repair your Office installation from the Control Panel (Windows) or reinstall Excel (Mac) — the add-in is part of the core Office package.

Solver on Excel for the Web, iPad, or SharePoint

Desktop Excel loads Solver as a native add-in, but browser-based Excel and the iPad app use a different system: Office Add-ins from the Microsoft Store. If you’re using Excel Online with Office 365, the Excel Web App in SharePoint, or Excel on an iPad, follow these steps:

1. Open your workbook in the browser or iPad app.
2. Go to the Insert tab and click Add-ins (or Office Add-ins).
3. Search for Solver Free by Frontline Systems — this is the official version for web and iPad.
4. Click Add to install it into your workbook.

The web/iPad version runs as a task pane add-in rather than a ribbon button, but the functionality is the same. Frontline Systems is the same company that developed the solver engine Microsoft uses in desktop Excel.

Load Steps at a Glance

Common Mistakes That Block Solver

Most “Solver not showing up” problems come from three patterns. Microsoft’s Solver add-in support page documents all of them, and each has a straightforward fix.

• Searching the ribbon before loading the add-in. Solver is invisible until you check the box in Excel Add-ins. Going straight to the Data tab and looking for it won’t work — load it first.
• Following Windows steps on a Mac. The Mac path is Tools > Add-ins, not File > Options. Using the wrong path makes users think the add-in is missing when it’s right where it should be.
• Stopping when Solver isn’t in the add-in list. Missing from the list doesn’t mean absent. The Browse button and a quick search for Solver.xlam usually finds it. If that fails, a repair of Office brings it back.

Troubleshooting Checklist — Solver Still Won’t Load

Load Solver in 30 Seconds: The Final Steps

Everything above distills to one short procedure that works for 9 out of 10 users. Start here, and you’ll have Solver running before you finish reading this paragraph.

1. Windows: File > Options > Add-ins > Manage Excel Add-ins > Go > check Solver Add-in > OK. Solver appears on the Data tab.
2. Mac: Tools > Add-ins > check Solver.xlam > OK. Solver appears on the Tools menu.
3. Web/iPad: Insert > Add-ins > search “Solver Free” > Add.

If the add-in isn’t in the list, click Browse and locate Solver.xlam — it’s inside your Office installation folder. When prompted to install, click Yes. That covers every platform and every edge case.