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. 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. ![]()
0 Comments
Leave a Reply. |