I'd guess you don't have the Analysis Toolpak Add-in installed and are
using XL03 or earlier (just guesses since you didn't say what version of
XL you're using).

Load the add-in using Tools/Add-ins...


In article ,
Connie Martin wrote:

I received a spreadsheet via e-mail and when I opened it all was fine.
Formulas appearing to working perfectly. As soon as I saved it to my
computer a whole column changed to #NAME? in place of the values that were in
their. The formula in the first cell is:
=IF(I42="","",NETWORKDAYS(A42,I42,NonWorkDays2008)-1). The named range
"NonWorkDays2008" is in a worksheet within the same workbook. What would
cause this? This was not doing this on the computer it was sent from.
Connie