View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default Formula displays as formula, not as result

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?