How To Download Analysis Toolpak For Excel 2011 Mac

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: 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. Subscribe via Email. Chrome toolbar for mac. 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.

Excel 2011 does not include the Analysis ToolPak. For an alternative, type 'Analysis ToolPak' into Excel's Help, and view the 'I can't find the Analysis ToolPak' item. I understand your first paragraph as saying you have installed Mac Excel 2011 version 14.3.2, so I don't understand your second paragraph.

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: and If the problem persists after implementing these solutions, do 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!