View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier Roger Govier is offline
external usenet poster
 
Posts: 2,886
Default Automatic value is malfunctioning

Hi Annie

ToolsOptionsCalculationtick Automatic

--
Regards

Roger Govier


"annie" wrote in message
...
First-I am a beginer: Each time I make a new change in to a cell, the
final
value cell does not automatically change. For example:
My first entry: 1 + 1 = 2
My changes: 1 + 7 = 2, the final value should automatically change
to the
number 8; but it does not unless I manually double click on the final
value
cell and then click the green check mark each time.

How can I fix this problem?
--
annie