none
Data analysis plus tool pack on excel 2010

Answers

  • Hi,

     

    Can you provide the detailed symptom of this issue? Did you encounter any error when trying to use it?

     

    Have you enabled it in the Add-ins?

     

    The Analysis ToolPak is a Microsoft Office Excel add-in program that is available when you install Microsoft Office or Excel. In Excel 2010, improvements have been made to many of the functions that the Analysis ToolPak uses.

     

    To use the Analysis ToolPak in Excel, you need to load it first.

    =================

    1. Click File, and then click Options.

    2. Click Add-Ins, and then in the Manage box, select Excel Add-ins.

    3. Click Go.

    4. In the Add-Ins available box, select the Analysis ToolPak check box, and then click OK.

    Tip    If Analysis ToolPak is not listed in the Add-Ins available box, click Browse to locate it.

    If you get prompted that the Analysis ToolPak is not currently installed on your computer, click Yes to install it.

     

    5. After you load the Analysis ToolPak, the Data Analysis command is available in the Analysis group on the Data tab.

     Note   To include Visual Basic for Application (VBA) functions for the Analysis ToolPak, you load the Analysis ToolPak - VBA add-in the same way that you load the Analysis ToolPak. In the Add-ins available box, select the Analysis ToolPak - VBA check box, and then click OK.

     

    Best Regards,

     

    Sally Tang

    • Marked as answer by Sally Tang Thursday, November 18, 2010 6:50 AM
    Monday, November 15, 2010 7:25 AM

All replies

  • Hi,

     

    Can you provide the detailed symptom of this issue? Did you encounter any error when trying to use it?

     

    Have you enabled it in the Add-ins?

     

    The Analysis ToolPak is a Microsoft Office Excel add-in program that is available when you install Microsoft Office or Excel. In Excel 2010, improvements have been made to many of the functions that the Analysis ToolPak uses.

     

    To use the Analysis ToolPak in Excel, you need to load it first.

    =================

    1. Click File, and then click Options.

    2. Click Add-Ins, and then in the Manage box, select Excel Add-ins.

    3. Click Go.

    4. In the Add-Ins available box, select the Analysis ToolPak check box, and then click OK.

    Tip    If Analysis ToolPak is not listed in the Add-Ins available box, click Browse to locate it.

    If you get prompted that the Analysis ToolPak is not currently installed on your computer, click Yes to install it.

     

    5. After you load the Analysis ToolPak, the Data Analysis command is available in the Analysis group on the Data tab.

     Note   To include Visual Basic for Application (VBA) functions for the Analysis ToolPak, you load the Analysis ToolPak - VBA add-in the same way that you load the Analysis ToolPak. In the Add-ins available box, select the Analysis ToolPak - VBA check box, and then click OK.

     

    Best Regards,

     

    Sally Tang

    • Marked as answer by Sally Tang Thursday, November 18, 2010 6:50 AM
    Monday, November 15, 2010 7:25 AM
  • I found, under Excel 2010, Data Analysis Plus boxplot generates an error and the plot is nolonger boxplot looking.  Gary Krenz

    Thursday, January 20, 2011 4:43 PM
  • This person is talking about the 'Data Analysis Plus' add-in (which is third party software), not the 'Analysis ToolPak' which is included in Excel. The 'Data Analysis Plus' add-in should be manually installed in Excel, by copying the stats.xls file in the C:\Program Files\Microsoft Office\Office14\XLSTART folder.

    However, on start-up, the following error will pop-up:

    Compile error in hidden module: code.
    This error commonly occurs when code is incompatible with the version, platform, or architecture of this application.

    So I guess the 'Data Analysis Plus' add-in is compatible with Excel 2007 only, not with 2010 versions.

    • Proposed as answer by k_vdzande Friday, August 19, 2011 10:10 AM
    Friday, August 19, 2011 10:09 AM
  • It all goes back to the installation actually.  After they make sure the Microsoft Data Analysis is enabled as Sally Tang shows above then they need to install the Data Analysis Plus program.  When they get to the point of choosing a destination folder it defaults to Office12, when it needs to be in Office 14.  So they need to go up two levels choose Office 14 from the list, then the XLSTART at the bottom of the list and then OK and continue on with the installation.  It then should install nicely and work, or so it did on my computer just now while trying to help a student.  You need to install it both places I am not sure since I already did the Office 12 first and that did not work, before I saw the Office 14 and tried there and it worked.
    Sunday, March 24, 2013 11:17 PM