Formula erros =#N/A

T

Tia

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
 
D

Dave

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.
 
T

Tia

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 ?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top