View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Empque Empque is offline
external usenet poster
 
Posts: 1
Default Formula displays as formula, not as result

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?