Hi Guys,
well , I owe a pint to he who asketh, is it set to manual !
Now note I hadnt a clue how to even do that.
I google excel not adding up, someone gets told to go to Formulas tab>calculations Options. there is an Auto and a manual, I do so , and ye gods, its on manual.
which the post says does this and that. I switch it to Auto, and all is fixed !


Now Excel did that, I certainly didnt. so the worrying thing is, how the heck did that get like that ?


Is there a keystroke como that might have done it ?


I have never evre gone to that tab let alone that setting.


but it is fixed, could have seen me typing everything out or copy pasting values and formulae to a new workbook, taking months and wiping out any chance of ever getting operational again. years and years of work blasted to oblivion.


The power of forums, honestly can I buy you a pint or a new car (joking on the latter)


DBenz