A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Setting up and Configuration
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Excel 2003 Add-In: Analysis ToolPak



 
 
Thread Tools Display Modes
  #1  
Old March 1st, 2007, 03:42 AM posted to microsoft.public.excel.setup
Peter - Student
external usenet poster
 
Posts: 1
Default Excel 2003 Add-In: Analysis ToolPak

Hi,
This add in name - Analysis ToolPak - appears when I click
Tools | Add-Ins
Then I tick the box...etc
Also I've browsed/searched for it in "Add-Ins" & some others - ANY OTHER
LOCATIONS I SHOULD TRY?; MAYBE MY OFFICE 2003 CD - HOW WOULD I DO THAT PLEASE?
But in any case I get no "Data Analysis" command on the Tools Menu, as there
should be I believe - IS THIS DIFFERENT FROM THE "DATA" MENU?

So I think its not there, on my computer, and is probably on my Office 2003
CD - OR CAN I DOWNLOAD IT?

3 Questions:
Before I use my Office 2003 CD, where else, what folders on my computer,
should I first look for the Add-In (Analysis ToolPak)?

If necesary, how, what do I do, to get the Add-In (Analysis ToolPak) from my
Office 2003 CD?

Can I download it?

Thanks & best wishes, Peter Dunne.
  #2  
Old March 1st, 2007, 05:14 PM posted to microsoft.public.excel.setup
Gord Dibben
external usenet poster
 
Posts: 20,252
Default Excel 2003 Add-In: Analysis ToolPak

Peter

If the ATP is listed in ToolsAdd-ins and you get no error message when you
checkmark it, it is installed.

Perhaps you have ToolsCustomizeOptions "always show full menus" unchecked?

You could also try re-setting the Worksheet Menu Bar.

ToolsCustomizeToolbarsWorksheet Menu BarReset.

To answer your question about where is it located..........

The default location on a regular installation is in the folder

C:\Program Files\Microsoft Office\Office11\Library\Analysis

There will be 4 files in the Analysis folder.

ANALYS32.XLL
FUNCRES.XLA
ATPVBAEN.XLA
PROCDB.XLA


Gord Dibben MS Excel MVP




On Wed, 28 Feb 2007 19:42:08 -0800, Peter - Student Peter -
wrote:

Hi,
This add in name - Analysis ToolPak - appears when I click
Tools | Add-Ins
Then I tick the box...etc
Also I've browsed/searched for it in "Add-Ins" & some others - ANY OTHER
LOCATIONS I SHOULD TRY?; MAYBE MY OFFICE 2003 CD - HOW WOULD I DO THAT PLEASE?
But in any case I get no "Data Analysis" command on the Tools Menu, as there
should be I believe - IS THIS DIFFERENT FROM THE "DATA" MENU?

So I think its not there, on my computer, and is probably on my Office 2003
CD - OR CAN I DOWNLOAD IT?

3 Questions:
Before I use my Office 2003 CD, where else, what folders on my computer,
should I first look for the Add-In (Analysis ToolPak)?

If necesary, how, what do I do, to get the Add-In (Analysis ToolPak) from my
Office 2003 CD?

Can I download it?

Thanks & best wishes, Peter Dunne.


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:36 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.