How come some worksheets automaticly change sums and others don't.

T

T.D.

If I have a colume of numbers and add a new one, some of my worksheets will
automaticly change Sums and some won't. What am I doing?
 
G

Gord Dibben

T.D.

Does it re-calculate if you hit the F9 key?

If by "worksheets" you mean "workbooks", you may have calculation set to
manual on those workbooks that don't calculate.

Calculation mode is a workbook property.


Gord Dibben Excel MVP
 
B

Bob Phillips

Has one worksheet had enablecalculation set to false?

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top