Onde está o suplemento do Solver no Microsoft Excel 2007?

Question

Estou procurando o Solver no Microsoft Excel 2007, mas não consigo encontrá-lo. Como posso encontrá-lo?

    

Answer 1

Você precisa carregá-lo primeiro . Observe que você pode ter que manter o CD de instalação do Office pronto.

• Click the Microsoft Office Button , and then click Excel Options.

  

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

• Click Go.
• 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 prompted that the Solver Add-in is not currently installed on your computer, click Yes to install it.
• After you load the Solver Add-in, the Solver command is available in the Analysis group on the Data tab.

    

Answer 2

Seguindo este artigo do kb para o excel 2007 mostra que você precisa instalar o suplemento:

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

1. Click the Microsoft Office Button , and then click Excel 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.
   1. Tip If Solver Add-in is not listed in the Add-Ins available box, click Browse to locate the add-in.
   2. 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.