Hi

I can not work out why but my excel is now deciding not to use logic when calculating formulas. I have Auto turned on, and checked all usual things but an example (although simplified) is this:

Jan calculation is Z1*A1
Feb calculation should be Z1*A2
March calculation should be Z1*A3
and so on

however I am getting

Jan calculation is Z1*A1
Feb calculation Z2*A2
March calculation Z3*A3

so I understand this could happen if I am only highlighting the first cell as the example - but I can correctly fill 6 cells and then try to drag the autofill and it results in a break in the logic!!!!


A am trying to alter a 5 year budget which means I am manually changing the 1 letter in each formula cell - my god its annoying. It also seems to happen even on another pc when I email it so its catching!!!