I have been using a networkdays formula in my database eversince I started
it, but now when I try to either copy or create an new networkdays formula in
the worksheet I get a #NAME! error saying it doesn't recognize text. I have
also noticed that if I search for the networkday formula it doesn't appear.
Anyone know why? Did I miss an update?

Thanks, Susan

Check the Excel help for the NETWORKDAYS formula. Occasionally the Analysis
ToolPak Add-In can become disconnected. Disable and Re-enable it. Sometimes
it might need an Excel restart or even a machine reboot between the Add-In
being disabled and enabled again.
--
David Biddulph

"Susan" wrote in message
...
I have been using a networkdays formula in my database eversince I started
it, but now when I try to either copy or create an new networkdays formula
in
the worksheet I get a #NAME! error saying it doesn't recognize text. I
have
also noticed that if I search for the networkday formula it doesn't
appear.
Anyone know why? Did I miss an update?

Thanks, Susan

THANKS! THAT WORKED! I'm so glad I found this board!

"David Biddulph" wrote:

Check the Excel help for the NETWORKDAYS formula. Occasionally the Analysis
ToolPak Add-In can become disconnected. Disable and Re-enable it. Sometimes
it might need an Excel restart or even a machine reboot between the Add-In
being disabled and enabled again.
--
David Biddulph

"Susan" wrote in message
...
I have been using a networkdays formula in my database eversince I started
it, but now when I try to either copy or create an new networkdays formula
in
the worksheet I get a #NAME! error saying it doesn't recognize text. I
have
also noticed that if I search for the networkday formula it doesn't
appear.
Anyone know why? Did I miss an update?

Thanks, Susan

Glad it helped.
--
David Biddulph

"Susan" wrote in message
...
THANKS! THAT WORKED! I'm so glad I found this board!

"David Biddulph" wrote:

Check the Excel help for the NETWORKDAYS formula. Occasionally the
Analysis
ToolPak Add-In can become disconnected. Disable and Re-enable it.
Sometimes
it might need an Excel restart or even a machine reboot between the
Add-In
being disabled and enabled again.
--
David Biddulph

"Susan" wrote in message
...
I have been using a networkdays formula in my database eversince I
started
it, but now when I try to either copy or create an new networkdays
formula
in
the worksheet I get a #NAME! error saying it doesn't recognize text. I
have
also noticed that if I search for the networkday formula it doesn't
appear.
Anyone know why? Did I miss an update?

Thanks, Susan