It should be in

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

can you see if you have that folder, if so uncheck it under toolsadd-ins,
close excel,
move FUNCRES.xla into the above path/folder, restart excel. If you don't get
any error messages check it and see if it works. If you get an error
message, plop in the CD, select add or remove features, next window select
advanced, find exceladd-ins and remove it. When you are done,click
startrunregedit,
press ctrl + f and search for FUNCRES.xla and delete the path that's in
there, press F3 to search for it and delete each instance of funcres.xla
(there might be one or two). Now restart excel and check that it works OK
(don't install it), make a search for funcres.xla make sure you can't find
it. Now repeat and go into install again but this time check Analysis
ToolPak under advanced installation, if it uninstalled it should be a red x
marking that it isn't available, select run from computer, now it should be
installing.
Start Excel, go into toolsadd-ins and check it, that should do it.

I once did this on a friends computer and I made it work, he had removed the
add-in and then he put it in the wrong folder, then he got it working except
that he got this error message that it couldn't find it every time he
started it. The only way I was able to make it work was to remove the path
string from the registry, delete it using the Office CD and reinstall it
using the Office CD

Note that if you feel uncomfortable to mess around with the registry, don't
do it.If you do mistakes it can cause windows not to work properly so you do
it at your own risk. I do it all the time but that doesn't mean I will
guarantee it will work

--
Regards,

Peo Sjoblom

(No private emails please)


"Stan Brown" wrote in message
...
On Tue, 31 May 2005 16:38:17 -0700, "Peo Sjoblom"
wrote:
Thanks for responding.

Do you get an error with this formula

=WORKDAY(1,5)

Yes, I do: #NAME?.

if so then ATP cannot be installed correctly, uncheck it and close excel,
try again by checking it.

I tried that before, but following your message I tried it again.
Didn't help.

If it is not working, plop in the CD and install
ATP from there again.

SETUP thinks that it's already installed. I tried uninstalling it
and then reinstalling it as I said earlier, but it didn't help.

You can also search for it FUNCRES.xla, you can use the
browse button from toolsadd-ins and select it from there (after finding
it
doing a file search)

Did that -- it was in C:\Program Files\MSOffice\Library\Addins but
after using Tools - Addins - Browse I still get the #NAME? error
with =NETWORKDAYS.

Help! I've done everything right as far as I can see, but it's just
not working.

The only other thing I can thing to mention is that when I click
"Browse" in Tools-Addins it starts _not_ in the above Program Files
directory but in
C:\Documents and Settings\{user}\Application Data\Microsoft\Addins
Could that make a difference, and if so what can I do to correct it?

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/
"I feel a wave of morning sickness coming on, and I want to
be standing on your mother's grave when it hits."