Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Tia
I have a error but i cannot undrestand what is causing it b whenever i open put the formula and try it is working fine but whenever i close and open back an error is displayed in the formula "N/A#" with notice "file error : data may have been lost" i press ok than and all the formula's from my workbook are gone and a =#N/A is diplayed instead of the formula's I am trying to calculate the annual leave of each employee excluding the holidays so i use the following formula B24: From C24: Till Main!B$73:B$100 = official holidays for year 2007-2008 =NETWORKDAYS(B24,C24,Main!B$73:B$100) The question is what am i doing wrong and what can i do to prevent the loss of my formula's and data |