View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Networkdays Stopped Working - Again

If youre getting a #NAME error and NETWORKDAYS is unavailable in the
function wizard, despite ATP supposedly being loaded, there is a known bug
where ATP sometimes gets lost.
Usually just shutting down Excel and restarting will solve the problem.
--
David Biddulph

"Steve" wrote in message
...
Hi there -

The networkdays function stopped working in all my workbooks today. I
**DO** have the Analysis Toolpak installed and I **DO** have the Automatic
Calcuation Option turned on. Any thoughts?

Thanks,
Steve