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

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

Even if you installed ATP when upgrading you need to check it under
toolsadd-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


"Jonathan" wrote:

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