View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Bridgeman[_2_] Ron Bridgeman[_2_] is offline
external usenet poster
 
Posts: 4
Default 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