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.

Because add-in programs aren't supported in Excel for the web, you won't be able to use the Solver add-in to run what-if analysis on your data to help you find optimal solutions.

Oct 14, 2025 · Use Solver, a Microsoft Excel add-in program you can use for what-if analysis, to determine an optimal product mix.

Start using Solver to schedule your workforce in Excel. Learn how to use Excel's Solver add-in to create a staffing schedule based on your settings.

To install an add-in that is typically installed with Excel, such as Solver or the Analysis ToolPak, run the setup program for Excel or Microsoft Office and choose the Change option to install the add-in.

You set up Solver to use a range of binary changing cells by adding a constraint—select the changing cells you want to use and then choose Bin from the list in the Add Constraint dialog box. With this …

To get new add-ins, select Get Add-ins. To use add-ins you already have, select My Add-ins. The add-ins you'll see will depend on the kind of Microsoft 365 subscription you have. Get a VBA add-in such …

Although Goal Seek can accommodate only one variable, you can project backward for more variables by using the Solver add-in. By using Solver, you can find an optimal value for a formula in one …

Bei Solver handelt es sich um ein Add-In für Microsoft Office Excel, das zur Verfügung steht, wenn Microsoft Office oder Excel installiert ist. Wenn Sie das Solver-Add-In verwenden möchten, müssen …

Click the File tab, click Options, and then click the Add-Ins category. In the Manage box, select Excel Add-ins and then click Go. If you're using Excel for Mac, in the file menu go to Tools > Excel Add-ins. …