Hi,
Excel 2013
It has suddenly started doing this:-
I add some spending in the september column., total box at base doesnt change, oh dear.

I do the click in the total box for august that is correct, click copy then paste formula for september and get the august total appear.
oh dear oh dear.

lets cleanse it, delete the totals boxes Jan to dec.
click and drag upward for aug and click sum, and get £150, correct.
look at the formula and its correct.
click the total box and paste that using paste formula into Jan through to July.

get £150 for each box, damn !



I have done this thousands of times since 1998 so know the method.

It has done this on another sheet.
and another and another, does it everywhere.

Its as if Excels brain has ceased working.

This is my finances workbook with hundreds of sheets. Its ceased working in effect.

NIGHTMARE.

Has it reached some kind of sheet and entry limit ?

My current account page is a few thousand rows long by now etc.

HELP !

DBenz

Please post a sample sheet, crystal balls are in short supply nowadays. Thanks

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Is your calculation set to manual?

__________________
Alan עַם יִשְׂרָאֵל חַ Using O365 v2505

Hi,
whats best way of grabbing a sheet retaining what gremlins might be on it and the entire workbook ?


Hi calculation set to manual, dunno, how do I check. I am not aware of altering that ever, but might it have got switched somehow ?
Its always been the default method, since decades ago, by that I mean I have never used anything other than what came out of the box. so where do I look for that to answer that one ?


DBenz

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

Thanks for the feedback. Glad to hear you are operational again.

__________________
Alan עַם יִשְׂרָאֵל חַ Using O365 v2505

A small acknowledgment of my ( maybe useless) help, would have been appreciated...

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

I myself never use Excel with manual calculation setting, and I'm not sure it isn't changed for current Excel versions, but I likely remember, that years ago I had the case, when I opened the Excel file with manual calculation settings, which was sent me, and my Excel was set to manual calulation as result.