0

Download Excel Solver Add In For 2003, 2007 and 2010

EmekaJan 19, 2012 | edited Aug 08, 2021 - by @Emeka

A reader of mine Stephen Chan asked me some time ago how to download the excel solver add in for 2003, 2007 and 2010, I didn't have the files for windows OS and Mac back then until now that I was solving a linear programming problem which required solver add-in for excel to solve.

With my ordeal searching for how to download and install Microsoft Excel Analysis Toolpak Add-In I thought that I should also share the Excel Solver add-in download and installation with you. I know that many people are vigorously looking for this Microsoft Excel Solver Add-In and many have probably given up the search and have gone ahead to buy and install a new Microsoft Office suite.

Microsoft excel solver add in is basically used in solving a range of mathematical and statistical problems. It is a particularly handy tool for those of us in business school. If you take classes like Business Statistics, Managerial Economics and the introductory College Algebra, you are definitely going to have Microsoft Excel Add-in installed assuming you don't have it installed already.

You might ask how do I know if my current Microsoft office suite does not have solver add-in, you will know if when you try to load it, you get an error dialog that the following files are missing:

Solver.dll
Solver.xla

Okay enough of the dribble, let's get down to practicals. Now I am going to show you how to download and install Microsoft Office Excel Solver Add In:

Download Microsoft Office Solver Add In:

Click here to download: Excel Solver Add-In

Go to your download folder or the directory on your computer where you downloaded the file above. Unzip the zipped folder by right clicking on it and clicking on ?extract file? take note of the directory and the extracted file's name.

Installation of Excel Solver Add-In:

Run your Microsoft Office excel program, select tools, then add-ins. Click on the browse button and find solver.xla file in the zipped folder you extracted above, don't worry about the solver.dll as it will be automatically loaded. You will notice that the ?solver add-in? option is now available, then click ?OK?, after that click on tools, you will now see the solver option.

If you have any questions or comments about this guide please add it in the comment section below, I would appreciate your feedback.

Emeka@Emeka+ Follow
Dakkar Author Apr 23, 2013
0

How to install solver from excel 2010 in excel 2007?
Ps. Sorry for my english.

edited Apr 23, 2013 - by @Dakkar28293
Paul Author May 25, 2012
0

Hi,

When I do this with excel 2003 by downloading, extracting and trying to load Solver, it says it can't find the files it needs? Is there any way to fix this?

edited May 25, 2012 - by @Paul28945
Richard Author Sep 01, 2016
0

Dear All,

Thank you for the information provided above. I installed the Solver and Data Analysis pack you provided as I was not able to download these add ins from excel. To my surprise, both Solver and Data Analysis add ins were already in the Excel Library. So, at the moment, I can't still see where or how to utilise both Solver and Data analysis, as they seem not ti be available. Would you have any suggestion on how I could fix this?

Thank you for your time.

edited Sep 01, 2016 - by @Richard29029
Valeria Author Sep 07, 2012
0

hi, I do it in excel 2007 but when I try to solve something it says: Solver32.dll is unavailable ? you will be able to define and edit Solver models, but not actually solve them. To fix this please use Exel setup to reinstall Solver.

edited Sep 07, 2012 - by @Valeria29258
0
Emeka+ Follow
joinedJul 31, 2021

More from @Emeka