Excel 2007 cannot install the Add-in solution

Source: Internet
Author: User

Opened the mail today to see a friend sent me an e-mail, the full text as follows (slightly deleted):

Recently, we have been studying mathematical models and using solver to compute them. Before using Excel XP, you know to load related macros in a tool, and then you can solve them smoothly. But in Excel 2007 you can't find the north:

The first is the add-in, click the Office logo icon in the upper-left corner-"Excel Options"-"Add-ins", select Excel add-in in the following management Drop-down list, go to, pop up the Add-Ins dialog box, check Solver add-ins, and make sure that a dialog box pops up (see figure 1);

But there is no legendary "analysis" group under the Data tab? Then look at "hypothetical analysis" in the Data Tools group and Solver-independent.

In addition, I noticed: Click on the Office logo icon in the upper left corner, Excel options, add-ins, solver, Analysis ToolPak, etc. are grouped in the inactive application add-ins.

Excel2007 "Solver"

I don't know the exact solution to this friend's problem. But he's doing the right thing. Solver in Excel 2007 uses the Office buttons-Excel Options-add-ins-Excel Add-ins-go to-Add-ins dialog box-tick Solver add-in "-OK, this is the general step.

The caveat is that if this is the first time, a dialog box will pop up after clicking OK, asking you to install the add-in (Figure 2).

It is completely ready to use after installation, as shown in Figure 3.

For the problem with that cue box, the solutions are as follows:

Under the Windowssystem32 directory of the system letter, execute regsvr32 fm20.dll, and register the file to load it.

Because a Solver macro requires SOLVER32.dll file guidance, there is no way to find a Solver macro without loading Fm20.dll,office 2007.

Classification:
  • Excel Tutorials

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.