This is not the normal experience when XL2003 files are opened in XL2007
Could it be that these cells are formatted as text?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"Empque" wrote in message
...
A Excel 2007 workbook, converted from 2003, is displaying formulas instead
of
their results when the formulas refer to a different worksheet in the same
workbook. The "Display formulas in cells instead of calculated results"
option is turned OFF for all worksheets. Does anyone know what can cause
this?