Good to hear and happy you can now get to work on those Data Analysis functions

e.g. Anova: Two-Factor With Replication


Gord

On Thu, 10 Jan 2008 10:53:03 -0800, achangcw
wrote:

Gord - You're the best! I did the "run from my computer" and it works like a
charm.

Thanks!!!
Anita

"Gord Dibben" wrote:

If the ATP is offered as one of the Add-ins in ToolsAdd-ins, I would surmise it
has been installed with the typical installation of Office but somehow lost its
way<g

Have you done a file search for Funcres.xla and any of the other files I
posted?

Before going to next steps open Excel and try HelpDetect and Repair.

If no joy go to next......................

Go to Control Panel and add/remove program.

Scroll down to MS Office(your edition)2003 and Change or Remove.

Select ChangeAdd or Remove FeaturesChoose Advanced Customization of
ApplicationsMicrosoft Excel.

Expand and select Add-ins and ATP........is it installed to "run from my
computer"?

If not, install it.

Have your CD ready.


Gord

On Wed, 9 Jan 2008 17:27:03 -0800, achangcw
wrote:

Thanks Gord. There is no Analysis Folder under the Library folder. Under
the Library Folder, there is only one Excel Add-in file for Internet
Assistant VBA.

I do have the program CD. In Excel, under Tools, Add-ins, Analysis Tool Pak
is one of the available choices. But the currently installed programs under
Control Panel; Add/Remove Program, there is no APT installation.

Thanks,
Anita


"Gord Dibben" wrote:

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

If not found there, suggest you try the control panel add/removechange and go
in and remove the ATP installation then re-install.

Assuming you have the installation CD, of course.


Gord Dibben MS Excel MVP


On Wed, 9 Jan 2008 13:49:09 -0800, achangcw
wrote:

I had similar problem as brunnsu and tried the solutions offered here. Looks
like my Add-ins are not in the proper folder. I tried searching for the .xla
files but nothing found related to the Analysis ToolPak I needed. Any help
would be appreicated.

achangcw

"Ron Rosenfeld" wrote:

On Fri, 30 Mar 2007 12:24:02 -0700, brunnsu
wrote:

I do not seem to have all functions with the Excel2003. For example INTRATE
and EFFECT is not there when I try to insert a function. How to I get these
functions into my Excel program?

What happens when you try to use them?

It might be useful if you looked at HELP for those functions:

--------------------------------------------------------------------------
If this function is not available, and returns the #NAME? error, install and
load the Analysis ToolPak add-in.

How?

On the Tools menu, click Add-Ins.
In the Add-Ins available list, select the Analysis ToolPak box, and then click
OK.
If necessary, follow the instructions in the setup program.
--------------------------------------------------
--ron