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."