Download Excel Analysis Toolpak Add-In – 2003, 2007
 |
We were recently given home work in Business Statistics. The home work is about Histogram and stem-and-leaf data analysis. I thought that it would be most convenient to have it done using excel.
So I jumped on my microsoft office 2003 excel, then tried to install the analysis toolpak but I got an error dialog saying that the necessary file which is pro11.msi is missing.
I immediately invaded Google, searching and scouring to see if I can download it. I eventually did and installed it, but that didn’t stop the error dialog from popping up again.
I went back to Google again to see if I can get suggestions on how to fix the error and probably get the missing file; whatever the heck it is. I later found out from forum suggestions that the following files are missing;
ANALYS32.XLL
FUNCRES.XLA
ATPVBAEN.XLA
PROCDB.XLA
To cut long story short, it took me almost 24hrs looking for these said files. I eventually found them, so I thought I should share them with those who are still probably immersed in the search engines looking for the Microsoft Excel Analysis Toolpak add-in before they get drowned, because honestly it was at the point of giving up the search that I found them in a zipped folder link on obscured location on techyguy’s forum.
Download Excel Analysis Toolpak Add-In:
Click here: Excel Analysis Toolpak Add-In
Installation:
Unzip the folder and copy the file contents into this directory; C:\Program Files\Microsoft Office\OFFICE11\Library\Analysis
If you don’t have Analysis folder in the Office11 Library, create one. Just know that the folder should look like the one above.
After doing that, open excel, click on tools, then click on add-ins, you will see analysis toolpak, tick the box and install. It should work.
If you have problems or suggestions you can add them in the comment section below.
Related Videos:
Download Excel Solver Add In For 2003, 2007 and 2010
Customizing Print Area and Print Titles in Excel 2007
Microsoft Office Feed
So far I haven’t had problems with the excel analysis toolpak add-in for 2003
For those of you with Microsoft office Excel 2007, did you have problems with the analysis toolpak add-in files?
Do I create Analysis, Library and Office folders if I don’t already have an OFFICE11 folder? Thanks!
Hello Hakeem, I don’t know the version of office you use. If you can locate the library folder in your current office directory, then that’s where you need to create the analysis folder and then the toolpak files. However, if you don’t have library folder, I would suggest you create the office11 folder and do the rest just like I outlined in the article. If you still have problems after doing that, let me know.
I think Microsoft should make files like analysis toolpak add-in available on their website.
I really think that Business statistics is a tough course.
sound!!
Wow, thanks sooooooo much for this download. I needed to use this toolpak for a class and for whatever reason didn’t have it on my home computer. Microsoft was completely useless as always but google helped find the answer. Thanks again for keeping me from failing! =)
YOU MADE MY DAY. GLAD I FOUND THIS THE NIGHT BEFORE MY ANALYTICAL CHEMISTRY DRIVER’S TEST
Hi Sir
When I install the solver toolpak add-in and I also get the same error dialog saying that the pro11.msi is missing.
Since I do not have the MS Professional Office Installation CDs on hand, I need to have solver to work for my project assignment urgently.
Could you zip the necessary files of the solver add-in for me and teach me how to install the missing files too?
Thanks very much.
Cheers
Stephen
Hello Chan,
I already provided the link to download the zipped toolpak add-in folder in the article with directions on how to download and install it. Anyway, let me repeat it here for you. Download the zip file – http://imarketingbiz.net/Excel%20Add-ins.zip after that, unzip and move the contents to this directory – C:Program Files/Microsoft Office/OFFICE11/Library/Analysis if there is no such directory in your PC, create one one, however make sure it looks just like the one here. If you have further problem, share it here.
take care.
Dear Sir
For the Analysis Add-in, I have already followed your procedure and it works.
But right now, my problem is that I need to install the another “Solver Add-in”. You can find that “Solver Add-in” from Excel 2003 from Tools -> Add-in. When I tick to select it, I meet the same error dialog saying that the necessary file which is pro11.msi is missing.
Really need your help! Could you check for me how to fix it?
Really really thanks for great help first.
Cheers
Stephen Chan
Do you use mac or windows?
Hello Chan,
The one I have is for only Mac users. I will keep looking for you, If I come across any, I’d let you know.
Hello Chan,
I am guessing that you’ve probably downloaded the solver files already since it’s been a long time. For those who might need it, here is how to download and install Microsoft Office Excel Solver Add-In
You are my hero