Why do I still get "#NAME?" when I have loaded the Analysis Toolp.

J

Jonathan

Since upgrading to Office 2003, my ACCRINT function no longer works. I have
Analysis Toolpak add-in loaded but still get "#NAME?# instead of a value. Any
ideas?

Jonathan
 
P

Peo Sjoblom

Even if you installed ATP when upgrading you need to check it under
tools>add-ins
If it is checked what happens if you type another ATP function like

=NETWORKDAYS(A1,A2)

if yoiu get the name erro try to uninstall ATP (uncheck it) and restart
excel, then install it again (check it) If same thing happens post back


Regards,

Peo Sjoblom
 
Top