LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 79
Default Formula erros =#N/A

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 09:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"