R
Réal
Hi everyone,
The problem I have is serious with the function yearfrac.
We have migrated from Excel 2003 to Excel 2007 with people sitll working on
2007. People with Excel 2007 still save documents in 2003 format.
Sometimes, not consistently, when we open a Excel 2003 document that uses
yearfrac, the content of the cell is replace by #N/A and display the old
value calculated by the yearfrac fonction. I read on some blog people
reporting the same problem but no solution.
What is causing that! Can someone help me?
The problem I have is serious with the function yearfrac.
We have migrated from Excel 2003 to Excel 2007 with people sitll working on
2007. People with Excel 2007 still save documents in 2003 format.
Sometimes, not consistently, when we open a Excel 2003 document that uses
yearfrac, the content of the cell is replace by #N/A and display the old
value calculated by the yearfrac fonction. I read on some blog people
reporting the same problem but no solution.
What is causing that! Can someone help me?