Why my spreadsheet suddenly gave me #value msg and changed my chart line color??

[tdrg]

I opened an Excel file (52 MB) this morning. The date column with work day formulas (=workday(previous cell, 1) gave me error message "#value". But when I manually typed in the date, it shows as 1/1/1900. Any one knows why?

The more wired thing is -- the charts that are based on the data also changed. The lines that used to be grey now are pink and green!

Any clue? Virus? Excel formula limit??

Your help is greatly appreciated!

 

[Sektor]

Can ya post one row with this formula?

 

[tdrg]

Hi Sektor, thank you for the quick reply. I pasted a printscreen of the file. After close and reopen the file several times, it is working now. But this problem happens from time to time. The error started from cell C6146 (you can see the formula from the top bar), and showed as "#value" or "#ref".

-- removed inline image ---

 

[tdrg]

the forum doesn't allow me to do the attachment...(why)
I attached the printscream on Google document. see link
https://docs.google.com/document/d/1...thkey=CMSZhJQL