Software

Ask something
Question Locked

Excel Solver

0 helpful
3 replies

by peggysue.carmack

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Can anyone tell me where to find Excel Solver in the 2007 version. I have looked under tools and data but I can't seem to find it. I'm use to the 2003 version and I can find it there but the way the 2007 version is set up it makes it difficult to find things. Can anyone direct me?

3 replies

by bizzo

Not having used Excel 2007, this is a bit of a shot in the dark.

Solver isn't installed as an add-in as standard, so you'll need to add it in manually.

In Excel 2003, this is how you install an add-in, hopefully in 2007 it would be similar:

1. On the Tools menu, click Add-Ins.
2. If the add-in you want to use is not listed in the Add-Ins available box, click Browse, and then locate the add-in.
3. In the Add-Ins available box, select the check box next to the add-in you want to load, and then click OK.
4. If necessary, follow the instructions in the setup program.

by mark.runge

Once the addin is installed, you can find solver on the "Data" tab.

This discussion is closed to new replies.