NETWORKDAYS formula
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 |
NETWORKDAYS formula
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 |
NETWORKDAYS formula
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 |
NETWORKDAYS formula
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 |
All times are GMT +1. The time now is 02:47 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com