Calculation confusion
Turn off automatic recalculation.
XL'07: Options, Formulas, Calculation options
Earlier versions: Tools, Options, Calculation
--
TedMi
"L" wrote:
Hi I'm a bit of an Excel virgin.
I'm trying to set up a formula so a particular cell will show a running
total of stock.
exampe
A1 quantity recieved today
A2 total quantity recieved =A1+A2
A3 quantity dispatched today
A4 total quantity dispatched =A4+A3
A3 shows current stock level. = A2-A4
However, everytime I edit a cell e.g quantity recieved today, all formulas
update and not just the modified cell. how can i stop this happening?
|