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.
Got Question About Download Excel Analysis Toolpak Add-In – 2003, 2007?
Ask now
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
Hola amigo ..ayudame…hago los pasos que me dices pero me aparece el error:
Microsoft Office Excel no puede tener acceso al archivo ‘C: \ … \ ANALYS32.XLL ”
Hay varias razones posibles:
- El nombre de archivo o la ruta no existe
- El archivo está siendo utilizado por otro programa
- El libro que está tratando de salvar tiene el mismo nombre que un libro abierto.
………………………..
Si me puedes decir el nombre que le tengo que poner en la carpeta de Library por favor o si me puedes dar otra solucion por favor.. y tengo Excel 2007 en Windows7.. gracias
Christian can you translate your comment to English?
Thanks for the files! Unfortunately, it didn’t work and I got the error message
Microsoft Office Excel cannot access the file ‘C:\…\ANALYS32.XLL’
There are several possible reasons:
- The file name or path does not exist
- The file is being used by another program
- The workbook you are trying to save has the same name as a currently open workbook.
Tried all the suggestions mentioned in the previous posts, without success…
HOWEVER, if I open the ANALYS32.XLL file, I can use the functions of the add-in, very strange but at least I can use it…
Thanks Hanna for the feedback. I did a little research on your problem and came up with a possible solution to it. If your PC has Windows Vista, then the possible solution is as follows:
If your PC is 64-bit (x64), create this folder:
C:\Windows\SysWOW64\config\systemprofile\Desktop
If it is 32-bit (x86), create this folder:
C:\Windows\System32\config\systemprofile\Desktop
For more on this and other possible solutions visit: http://bytes.com/topic/net/answers/854715-windows-service-accessing-excel-file and http://social.msdn.microsoft.com/Forums/en-US/innovateonoffice/thread/b81a3c4e-62db-488b-af06-44421818ef91?prof=required
If the problem persists after implementing these solutions, do let me know.
MAM OFFICE PROFESSIONAL 2003 I ROBIE TAK JAK PISZE I DALEJ MAM TEN KOMUNIKAT PRO11. NSI FOLDERU ANALYSIS NIE MIAŁĄM SAMA ROBIŁAM
Hello, could you translate your language to English so I can understand your question?
Im native polish speaker and even I have problem to understand what she wants ; p
“I did all what you said and i still get message PRO11. I made folder Analysis myself.”
Ok did it work after creating the analysis folder? and what version of excel do you have?
it worked! thank you so much!
Thanks for your feedback, glad it did!
Really appreciate you putting this out there… saved me time and a headache!
Thank you so so so much for this! My Add-in worked originally, but I was unable to change it to English.
Everything works great so far, except that now every time I open Excel it tells me “FUNCRES.XLA is already open. Reopening will cause any changes you made to be discarded. Do you want to reopen FUNCRES.XLA?” Is it possible to get rid of this?
Thanks for your feedback Kim. Your problem seems strange to me as I have never encountered it before nor have I seen anyone with similar problem. However after a little search online, I think the solution here: http://contextures.com/xlfaqApp.html#AlreadyOpen might help you, if it didn’t resolve your problem, let me know.
Hello,
Apologies for the late reply, but lately I did not have the time nor patience to have another look. Thank you for the research!
I think (fingers crossed) I solved the problem. They were kind of one and a half offices installed (the newer english version did not overwrite all the older german version), so the folders with the analysis got mixed up. Replaced the original with yours now and after Excel “configurated” for half an hour the Analysis Toolpak seems works fine.
It is not the first time I had troubles with the language settings, windows and microsoft do not handle two languages too well.
Anyhow, thanks a million!
Kim thanks for the feedback. I am certainly happy that you finally resolved the problem.
I have MS Office 2003 installed in my pc, I checked and it is SP3.
I needed the Analysis ToolPak for a worksheet that is part of our school tasks to complete.
The first time I tried clicking on Tools > Add-ins, chose Analysis ToolPak and clicked OK
this was the result:
Microsoft Excel can’t run this add in.
This feature is not currently installed. Would you like to install it now?
Since I lost my installation disk, I downloaded the zip file in the link above,
extracted and copied the contents on the newly created “Analysis” folder.
I followed the instructions above for OFFICE11 but I still cant make it work as it is still trying to install but always resulting to not successful. Please help.
It shows this again:
Microsoft Excel can’t run this add in.
This feature is not currently installed. Would you like to install it now?
I clicked Yes and it started to install but a new window resulted which says
Microsoft Excel can’t run this add in.
The feature is not available.
Clicking OK, this shows again
Microsoft Excel can’t run this add in.
This feature is not currently installed. Would you like to install it now?
Clicking Yes, this shows yet again
Microsoft Excel can’t run this add in.
The feature is not available.
Then I click OK and this shows
Microsoft Office Excel cannot access the file ‘C:\…\ANALYS32.XLL’
There are several possible reasons:
- The file name or path does not exist
- The file is being used by another program
- The workbook you are trying to save has the same name as a currently open workbook.
As I also have the folder “Office12″, I also tried doing the latest instructions above but still none.
There is a folder “Office14″ and I also tried said instructions, still no go.
Please help.
Thanks in advance.
Hello Alvin,
Try installing all office features with “run all” on your computer option, after that try installing the add-in again. For more on this solution visit these links:
http://answers.microsoft.com/en-us/office/forum/office_2010-excel/microsoft-excel-cannot-acess-analysis-toolpak/9cd790e5-668b-4ced-84cd-0f0ab8049aba
http://www.excelforum.com/excel-general/364254-error-when-installing-add-ins.html
Hi, first of all thanks for the files! I am using Excel 2007 in Windows Vista Home Premium 32-bit version. I, like someone had previously mentioned before, do not have Office 11 in the folder. So I created the analysis folder in office 12 (which contained the Library folder) and placed the 4 downloaded files inside. I managed to install it properly, thanks to you. I hope you can edit the post by reminding the users that if they have office12 folder instead of office11 they can install it by creating the analysis folder there. Thanks again!
Thanks Anand for your recommendation, I will find time to edit the post. I am glad it helped you.
Yey! Thanks so much for this! I was having quite a headache getting this fixed!
Hello Ceejay, Thanks for your feedback, I’m happy it helped
Perfect….just what I needed. Thank you!!
Thanks Carissa, I’m glad it helped you.
I tick the box next to the addin and click OK but it tells me that it is not currently installed and gives me the option to install it but, when I click yes, it says, “Setup cannot find excel.en-us\ExcelLR.cab.” and tells me to browse to a valid installation source. The analysis folder was coming up empty so I downloaded your files (thank you!) and unzipped and added them but it is still telling me that this is an invalid installation source. There was an Office12, rather than an OFFICE11, which had a library/analysis folder that I put the file in so I tried creating OFFICE11/library/analysis folders and moving it there and still no luck. This is the 2007 version of Excel.
Hello Natalie,
It seems that the problem is from your MS Office 2007 installation and/or from a corrupt disk. Someone has a similar problem with yours and it got solved by cleaning the disk. Please refer to this: http://answers.microsoft.com/en-us/office/forum/office_2007-office_install/setup-cannot-find-excelen-usexcelurcab-browse-to-a/c083a3ce-2ba5-4bee-83be-f3143a746f18 let me know after following the instructions on the link above if you still get the problem so I can find more possible solutions to it.
It doesn’t work for me… I followed the steps and all I get is a suggestion to install the add-in, and when I click “no” it tells me that it cannot access the location that you’ve given (and I created an Analysis folder as you’ve mentioned)…
What should I do?
Thank you!
Hello,
I am not sure of the version of Microsoft Office that you have, but this should work for you if you have version 2003 or 2007. Nevertheless, try following the suggestion to install the add-in and click yes this time after making sure that your analysis toolpak files are in the right folder depending on your version of MS Office. For 2003 and 2007 it should be in this directory path: C:\Program Files\Microsoft Office\OFFICE11\Library\Analysis. If you don’t already have that path in place, then you should create it. Let me know if you still have problems after doing this.
Creating the path to the OFFICE 11 Library folder and then creating an ANALYSIS folder within the Library folder and placing the files you provided in the ANALYSIS folder definitely solved the problem I was having installing the Excel Analysis Toolpak in Microsoft Excel 2003. Thank you so much for sharing these detailed instructions!
Thanks Robert for your feedback, I am glad you solved your problem
I also followed the said steps but to no avail. The following message appeared: A required installation file SKU011.cab could not be found. Pls help.
Hello Genda,
From a little research I did on the problem of sku011.cab I found out that the issue is from your windows installation and not a microsoft office problem, to solve it, I recommend you follow the steps here: http://www.sku011cab.com however be careful when making changes to your windows registry.
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