If they are not on your system, or if you are missing some of them, then you can copy them from someone else's machine-provided that person is using the same version of Excel you are. You need all four of these files to use the full functionality of the Analysis ToolPak they should be located within the following default installation directory:Ĭ:\Program Files\Microsoft Office 15\root\office15\Library\Analysis In that case, you shouldĬheck to see if these four files are on your system. The easiest way to do this is with the Office Setup program, but that won't do you any good if you don't have the Office package.
#Downloading data analysis excel install#
If the Analysis ToolPak is, indeed, not listed in the Add-ins dialog box, then you need to install it. After you load the Analysis ToolPak, the Data Analysis command is available in the Analysis group on the Data tab.* If you get prompted that the Analysis ToolPak is not currently installed on your computer, click Yes to install it. * If Analysis ToolPak is not listed in the Add-Ins available box, click Browse to locate it. In the Add-Ins available box, select the Analysis ToolPak check box, and then click OK.Click Add-Ins, and then in the Manage box, select Excel Add-ins and Go.Click the File tab, and then click Options.Have you ever tried to load the Analysis ToolPak?įirst I suggest you try these steps and check if they work for you. If you want to use Data Analysis feature, you need to load the Analysis ToolPak first. Which version of Office are you using? First you should know this feature isn’t available in Office on a Windows RT PC.