The first is the add-in, click the Office logo icon in the upper left corner - "Excel Options" - "Add-ins", select "Excel Add-ins" in the management drop-down list below, go to the "Add-in" dialog box, and check " Solver Add-in", OK, a dialog box will pop up;

add-in

But there is no legendary "Analysis" group under the "Data" tab? Look at the "What-If Analysis" in the "Data Tools" group and it has nothing to do with Solver.

In addition, I noticed: Click the Office logo icon in the upper left corner, Excel options, add-ins, Solver, Analysis Tool Library, etc. are classified in "Inactive Application Add-ins".

Excel2007 "Solver"

The method of using "Solver" in Excel 2007 is "Office Button" - "Excel Options" - "Add-ins" - "Excel Add-in" - Go to - "Add-ins" dialog box - check "Solver Add-in" - OK, the general steps are like this.

It should be reminded that if this is the first time you use it, a dialog box will pop up after clicking OK, asking you to install the add-on.

It is fully ready to use after installation.

Compared with the previous version, the add-in of Excel2007 has changed its location. For some users who use Excel XP, they will feel confused when using Excel2007 for the first time. The add-in for Excel 2007 is located under the Excel options. If you don’t understand it, you can also find the answer from Solver.