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