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: 2
Default Netwrokdays and EOMONTH Functions return N/A when opening Excel sh

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Why do Excel functions return the text and not run? Bill Excel Worksheet Functions 1 September 25th 08 02:02 AM
EOMONTH to compare two dates (Excel 2003) sithjanitor Excel Worksheet Functions 4 June 6th 08 09:47 PM
Help with Excel array functions - select, add & return result [email protected] Excel Worksheet Functions 0 July 12th 07 06:36 PM
Excel Analysis Add-in EOMONTH generates #NAME? error Ray Excel Worksheet Functions 6 July 18th 05 07:00 PM
How about adding a quarterly function to Excel like its EOMonth? SDolley Excel Worksheet Functions 1 March 30th 05 06:58 PM


All times are GMT +1. The time now is 02:07 PM.

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"