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

Formula erros =#N/A
 

Hi,
It's possible that the workbook has become corrupt.
Create a new worksheet with just the formulas and data you have mentioned.
Try closing and opening it.
If it still works ok, you can then copy and paste remaining data into the
new book.
Regards - Dave.

Formula erros =#N/A
 

On Jun 4, 5:47*pm, Dave wrote:
Hi,
It's possible that the workbook has become corrupt.
Create a new worksheet with just the formulas and data you have mentioned.
Try closing and opening it.
If it still works ok, you can then copy and paste remaining data into the
new book.
Regards - Dave.

I did so but each time i copy it to a new workbook same ending all the
formulas are gone
what can i do to protect my formulas from being corrupted ?