Formulas no longer auto update with newly inserted data!

O

Oyitch

All of a sudden, I add sales numbers to a row that was
included in the summation. The sum function did not sum
the newly inserted information until I double-clicked on
the formula cell and re-entered. This now holds true for
all of my linked worksheets and formulas, rendering me
useless for entering additional data. Anybody know why
this is happening and how to remedy?
 
F

Frank Kabel

Hi
you probably have disabled the automatic calculation. Goto 'Tools -
Options - Calculation' and check 'Automatic calculation
 
H

helen

Thank you I had the same problem.

----- Frank Kabel wrote: -----

Hi
you probably have disabled the automatic calculation. Goto 'Tools -
Options - Calculation' and check 'Automatic calculation
 
Top