Networkdays shows as #NAME even though I have the toolpack instal.

K

Ken

After I upgraded to Office 2003 the networkdays no longer works. I then
uninstalled office, deleted all program folders and reinstalled Office 2003
clean. Still doesn't work. Help!
 
D

Domenic

If you've re-installed Analysis ToolPak, make sure that you've enabled
it...

Tools > Add-Ins > check Analysis ToolPak > Click OK

Hope this helps!
 
G

Guest

I made a post about this today but can't find it.

Yes, the Analysis Tool is checked. This is why I'm
confused.

Ken

-----Original Message-----
If you've re-installed Analysis ToolPak, make sure that you've enabled
it...

Tools > Add-Ins > check Analysis ToolPak > Click OK

Hope this helps!
 
M

Myrna Larson

Have you spelled the function name correctly?

I made a post about this today but can't find it.

Yes, the Analysis Tool is checked. This is why I'm
confused.

Ken
 
D

Dave Peterson

You may want to copy the formula and post it here.

(maybe it's a different typo that's causing the error.)



I made a post about this today but can't find it.

Yes, the Analysis Tool is checked. This is why I'm
confused.

Ken
 
C

Chip Pearson

NETWORKDAYS is part of the Analysis Tool Pak add in, so this must
be loaded. Go to the Tools menu, choose Add-Ins and select
Analysis Tool Pak from the list.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Top