View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default Formulas not updating when add new inputs

Hi
check if automatic calculation is disabled ('Tools -
Options - Calculate).
Enable this setting.

-----Original Message-----
We on occasion have a problem with cells that contains a
formula not updating when we enter new information in the
range of cells it is calculating; what would cause this?
The strange thing is that one day it will operate fine
and the next it will not.
.