Networkdays Function
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
|