On Wed, 1 Jun 2005 07:13:20 -0700, "Peo Sjoblom"
wrote:

If I understand you,
you're saying that even if FUNCRES.XLA is present in the above-
mentioned directory _and_ the Registry paths are correct, I should
still
1. Delete the above two registry keys
2. Add/Remove and uninstall the Analysis Toolpak
3. Start Excel and verify that it's not even listed in the
Add-ins.
4. Do another Add/Remove and reinstall ATP.
5. Go into Excel and tick the ATP.


I was able to get it working by doing

2.
1.
3.
4.
5.

I followed the steps in the order you said. After (2), only one key
was left in the Registry, and I deleted it., As you suggested, the
entire Analysis folder was gone. (3) was fine, and I checked that
FUNCRES.XLA was back in C:\Program Files\MSOffice\Library\Analysis.
(4) went fine, and (5) again appeared to work. I exited Excel and
restarted it, and verified that the ATP was still ticked. However,
when I tried another =NETWORKDAYS(D5,D6), with two dates in those
cells, I again got #NAME?.

Any other ideas? I'm completely stumped.

<rant
I'm really annoyed at Office 2003. Every application I use has
annoying bugs. Excel says it installs things but apparently it
doesn't actually install them. Access changes the settings on the
default printer when I click the little printer icon. Word breaks
the Alt-nnnn key inputs, and when I select text it highlights a menu
selection so that the Ctrl-C or Ctrl-X key doesn't work.
</rant


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