Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Why do Excel functions return the text and not run? | Excel Worksheet Functions | |||
EOMONTH to compare two dates (Excel 2003) | Excel Worksheet Functions | |||
Help with Excel array functions - select, add & return result | Excel Worksheet Functions | |||
Excel Analysis Add-in EOMONTH generates #NAME? error | Excel Worksheet Functions | |||
How about adding a quarterly function to Excel like its EOMonth? | Excel Worksheet Functions |