Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

 
 
Search
Microsoft Office Excel
  Search 
Search in
 
Search
 
Check for updates: (c) Microsoft
Office downloads
 
Microsoft Office Excel
 
 
Community TipsCommunity Tips Email this linkEmail this link Printer-Friendly VersionPrinter-Friendly Version Bookmark and ShareShare
Load the Analysis Toolpak
 

The Analysis Toolpak is an Excel add-in (add-in: A supplemental program that adds custom commands or custom features to Microsoft Office.) program that is available when you install Microsoft Office or Excel. To use it in Excel, however, you need to load it first.

  1. On the Tools menu, click Add-Ins.
  2. In the Add-Ins available box, select the check box next to Analysis Toolpak, and then click OK.

    Tip   If Analysis Toolpak is not listed, click Browse to locate it.

  3. If you see a message that tells you the Analysis Toolpak is not currently installed on your computer, click Yes to install it.
  4. Click Tools on the menu bar. When you load the Analysis Toolpak, the Data Analysis command is added to the Tools menu.

Note  To include Visual Basis for Application (VBA) functions for the Analysis Toolpak, you can load the Analysis Toolpak - VBA Add-in the same way you load the Analysis Toolpak. In the Add-ins available box, select the check box next to Analysis Toolpak - VBA.

Was this information helpful?
    
 
Share a helpful tip
Sign in to share a tip or question with the community.Sign in to share a tip or question with the community.

advertisement
Related Web Sites
 
Site Help | Accessibility | Contact Us | My Office Online | Office WorldwideClick here to switch to other Office Online sites worldwide
© 2009 Microsoft Corporation. All rights reserved. Legal | Trademarks | Privacy Statement
Microsoft