P
Prerna
Hi
I get the error "File may have lost data" - when I open a perfectly fine
working excel sheet after I have saved it in good condition.
This Excel sheet has many Networkdays and EOMONTh formulae. The values in
all the cells with these formulae get converted to #N/A when the above error
comes.
This is how this sheet behaves - The formulae work fine for a while but
suddnely when I open the sheet, these formula are replaced by #N/A in the
cells. If I apply the formula again in this sheet , I see the required
calculated values in those cells.
But I never know, when the problem will start coming again once I reopen the
sheet after saving it.
Can somebody point me to probable cause of the problem.
Thanks
Prerna
I get the error "File may have lost data" - when I open a perfectly fine
working excel sheet after I have saved it in good condition.
This Excel sheet has many Networkdays and EOMONTh formulae. The values in
all the cells with these formulae get converted to #N/A when the above error
comes.
This is how this sheet behaves - The formulae work fine for a while but
suddnely when I open the sheet, these formula are replaced by #N/A in the
cells. If I apply the formula again in this sheet , I see the required
calculated values in those cells.
But I never know, when the problem will start coming again once I reopen the
sheet after saving it.
Can somebody point me to probable cause of the problem.
Thanks
Prerna