Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#NAME?
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 |