Excel: How to Load the Solver Add-in

It's an Excel question this week!:

"I'm using Excel 2010. Where's the Solver Add-in?"

The Solver Add-in is included in the default installation of Excel 2010, so you probably don't need to worry about installing or purchasing anything extra. In order to use it for the first time, you need to load it.

Go to the 'File' tab, and choose 'Options'. Click 'Add-Ins', choose 'Excel Add-ins' (in the 'Manage' box), then click 'Go'. In the 'Add-Ins available' box, select the checkbox next to 'Solver Add-in'. If you don't see it in this list, you might need to click 'Browse' and find the location on your computer where it is stored.

Click 'OK' when you're done.

Now that it's been loaded, you can access the tool by going to the 'Data' tab. You'll find 'Solver' in the 'Analysis' group.

I hope this solved your problem! (I'm sorry, I couldn't resist the bad joke...)


Post a Comment