Try un-installing and re-installing the ATP, that usually works for
me.


HTH,
JP

On Mar 19, 2:04*pm, Ron Bridgeman
wrote:
Thanks. *I tried it, but it didn't help. I appreciate your response.
Ron



"Ross OZ" wrote:
Ron
Try using "TODAY" instead of "NOW"
I have had problems in other areas and the "TODAY" as fixed it.
"NOW" is to the second and "TODAY" is to the day only.
Hope it works for you

"Ron Bridgeman" wrote:

Workbook in question is password protected. When I unprotect it, the problem
goes away. Don't know why password protection would cause a problem, but is
there any way to deal with this and retain password protection?

"Ron Bridgeman" wrote:

When I enter "= NETWORKDAYS(DATE(2008,3,1),NOW())" into a cell in a
worksheet, it calculates perfectly. However, the second time that I close and
reopen the workbook, I receive a "#N/A" error. *(I can close and reopen the
workbook once without an error.) The Analysis ToolPak is installed.

Can anyone explain why this is happening? *Thanks- Hide quoted text -

- Show quoted text -