View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sherberg Sherberg is offline
external usenet poster
 
Posts: 2
Default CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP

Multiple wkshts same problem- formulas in cells are correct but the value
doesn't chg. I have to go to the formula line and click on it and then on
the ck mark to recalculate the formula. If I copy formulas across to
multiple cells the correct formula copies across but the value of the cell
copied appears in the cell. Is there something I need to disable/enable in
EXCEL? Help!!!