M2,XJS,S1000RR
I've made myself a spreadsheet on excel for all my finances etc, and linked all of the cells together to work out how much i should have left in my account etc...
Basically the problem is the cells do not auto update, for example:
A1 - £100
A2 - £30
A3 - =A1-A2
theorectically A3 should be £70 after the calculation, then if i went into A2 and changed it to £40 and press enter it should automatically update A3.
It has been doing this until recently, but now I have to alter A2 to £40, press enter, and then go into A3, put my cursor on the input line as if i am editing it, then press enter and it update.
Whats wrong, it just suddenly stopped working?
Basically the problem is the cells do not auto update, for example:
A1 - £100
A2 - £30
A3 - =A1-A2
theorectically A3 should be £70 after the calculation, then if i went into A2 and changed it to £40 and press enter it should automatically update A3.
It has been doing this until recently, but now I have to alter A2 to £40, press enter, and then go into A3, put my cursor on the input line as if i am editing it, then press enter and it update.
Whats wrong, it just suddenly stopped working?
