data not updating

[jxbeeman]

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

 

[Sandy Mann]

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[John C]

It sounds as if you are on manual calculation. Go to Tools-->Options, then
select Calculation tab, and ensure auto calculation is selected.

Or, if you want your workbook on manual calculation, you can force it to do
an update to current calculations by pressing F9.