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?

F1/ Circular reference
and then avoid using them.
--
David Biddulph

"L" wrote in message
...
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?

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?