Check Tools Options Calculation and make sure that Automatic is
selected.

XL take the Automatic/Manual setting from the first Workbook opened.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"jxbeeman" wrote in message
...
Hi, I have a problem with my formulas not updating to the correct value.
for
example i have 1 in col A and 2 in col B, and col C = A*B=2. The problem
is
that say I change col B to 5, Col C will still remain at 2. It will also
still remain at 2 if i drop down the formula again. The only way that it
will update is when you actually go into the formula click at the end of
it
and hit enter. At that point it will update to the correct value. I'm
just
wondering if there is a way to update all these formulas so that this does
not happen and so I don't have to manually go through all of the formulas.

Thanks, Josh