On Tue, 31 May 2005 19:49:06 -0700, "Peo Sjoblom"
wrote:
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.
Thanks for responding. Yes, FUNCRES.XLA is in the above folder.
(Sorry, in my previous message I said "Addins" instead of
"Analysis".)
Sorry -- I'm confused about your next instruction. You say if it's
there then I should mope it into the folder where it already is??
I'm guessing you mean if it's _not_ there.
I've already tried uninstalling and reinstalling the add-in.
Following your suggestion I looked in the Registry and found two
items with paths to FUNCRES.XLA; both had the correct path in the
string data.
HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\E xcel\Options\OPEN
and
HKEY_USERS\{lots of digits}\
Software\Microsoft\Office\11.0\Excel\Options
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.
I don't get any error message when Excel starts up. The only symptom
is #NAME? when I try to use NETWORKDAYS or other functions that the
help file says are in the Analysis Toolpak.
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
I mess with the registry all the time, but before I do this let me
make sure I understand what you're suggesting. 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 tried numbers 2 through 5 before posting my original article, but
if you're telling me to do 1 through 5 in sequence I'm willing.
--
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."