Load The Solver Add-in In Excel - Microsoft Support

Skip to main content Sign in with Microsoft Sign in or create an account. Hello, Select a different account. You have multiple accounts Choose the account you want to sign in with. Applies ToExcel for Microsoft 365 Excel for Microsoft 365 for Mac Excel 2024 Excel 2024 for Mac Excel 2021 Excel 2021 for Mac Excel 2019 Excel 2016 Excel for iPad Excel for iPhone Excel for Android tablets Excel for Android phones Excel Mobile Microsoft Office Microsoft365.com

The Solver Add-in is a Microsoft Office Excel add-in program that is available when you install Microsoft Office or Excel.

To use the Solver Add-in, however, you first need to load it in Excel.

WindowsmacOSAndroidiOSWindows Mobile

1. Go to File > Options

2. Click Add-Ins, and then in the Manage box, select Excel Add-ins.

3. Click Go.

4. In the Add-Ins available box, select the Solver Add-in check box, and then click OK.

   Notes: 

   •  If the Solver Add-in is not listed in the Add-Ins available box, click Browse to locate the add-in.

   • If you get prompted that the Solver Add-in is not currently installed on your computer, click Yes to install it.

5. After you load the Solver Add-in, the Solver command is available in the Analysis group on the Data tab.

1. On the Tools menu, select Excel Add-Ins.

2. In the Add-Ins available box, select the Solver Add-In check box, and then click OK.

   • If Solver Add-in is not listed in the Add-Ins available box, click Browse to locate the add-in.

   • If you get a prompt that the Solver add-in is not currently installed on your computer, click Yes in the dialog box to install it.

   After you load the Solver add-in, the Solver button is available on the Data tab.

The Solver add-in from Frontline Systems isn't currently available for Excel on mobile devices.

Solver is a free add-in for Excel. For more information, search for Solver in the Office Store.

The Solver add-in from Frontline Systems isn't currently available for Excel on mobile devices.

Solver is a free add-in for Excel. For more information, search for Solver in the Office Store.

The Solver add-in from Frontline Systems isn't currently available for Excel on mobile devices.

Solver is a free add-in for Excel. For more information, search for Solver in the Office Store.

Need more help?

You can always ask an expert in the Excel Tech Community or get support in Communities.

See Also

Define and solve a problem by using Solver

Overview of formulas in Excel

How to avoid broken formulas

Detect errors in formulas

Keyboard shortcuts in Excel

Excel functions (alphabetical)

Excel functions (by category)

Need more help?

Want more options?

DiscoverCommunity

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Microsoft 365 subscription benefits

Microsoft 365 training

Microsoft security

Accessibility center

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Ask the Microsoft Community

Microsoft Tech Community

Windows Insiders

Microsoft 365 Insiders

Was this information helpful?

Yes No Thank you! Any more feedback for Microsoft? Can you help us improve? (Send feedback to Microsoft so we can help.) What affected your experience? Resolved my issue Clear instructions Easy to follow No jargon Pictures helped Other Didn't match my screen Incorrect instructions Too technical Not enough information Not enough pictures Other Any additional feedback? (Optional) Submit feedback By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×