calc

[scottwilsonx]

I have a spreadsheet which runs a number of calculations using vba.

For example, if I have a value in A1 and a value in A2, and a formul
in A3: sum(a1+a2). if I alter A1 then it doesnt automatically updat
the sum in A3.
This used to work, but I now have to force the calc by pressing F9.

Any ideas what has happened? and how to fix it ?

Thanks
Scott

 

[Harald Staff]

Hi Scott

Menu Tools > Options, set Calculation to Automatic.

HTH.Best wishes Harald

 

[scottwilsonx]

Thanks, no idea how that box got changed!

Thanks anyway,

Scott

 

[Harald Staff]

Macros often turn it off to gain execution speed, it's a radical improvement
of performance. Those turn it back on at the end, but if the code terminates
for some reason then it may be left off.

Best wishes Harald