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.
QuickBooks Pro 2012For the business that is upand runningProductInformation QuickBooks Pro 2012 lets you organize your business finances all in oneplace so you can quic... Read more...
Microsoft Office Home & Student 2010 - 3PC/1User (Disc Version)Microsoft Office 2010 gives you powerful new tools to express your ideas, solve problems, and connect with people.
Related Videos:
Download Excel Solver Add In For 2003, 2007 and 2010
Customizing Print Area and Print Titles in Excel 2007
Microsoft Office Feed
Hello,
I did exactly what you wrote but the data analysis tab doesn’t show. My excel is excel 2003 and by opening Tools/Add Ins and clicking on Analysis ToolPak and Analysis Toolpak – VBA nothing actually happens. The files you mentioned are all there (in C:Documents and Settings/owner/Application Data/Microsoft/AddIns. Could you help to solve this prblem?
Hello Guy,
The right path is: C:\Program Files\Microsoft Office\OFFICE11\Library\Analysis and not C:Documents and Settings/owner/Application Data/Microsoft/AddIns are you sure you followed the right path as stated in the article? also the Analysis Toolpak – VBA I understand is for Macros while Analysis Toolpak is interactive. They are two different files. The download link in this article is for Analysis Toolpak and not for Analysis Toolpak – VBA. However, if I come across Analysis Toolpak – VBA files, I will provide the download link for it here.
You are my hero
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
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.
YOU MADE MY DAY. GLAD I FOUND THIS THE NIGHT BEFORE MY ANALYTICAL CHEMISTRY DRIVER’S TEST
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! =)
sound!!
I really think that Business statistics is a tough course.
I think Microsoft should make files like analysis toolpak add-in available on their website.
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.
So far I haven’t had problems with the excel analysis toolpak add-in for 2003