View original (French)

Excel spreadsheet is not working properly anymore.

Solved
Quartzite Posted messages 79 Registration date   Status Member Last intervention   -  
Quartzite Posted messages 79 Registration date   Status Member Last intervention   -

Hello everyone.
I am coming back to this forum to ask for your help to solve the following problem:

My Excel spreadsheet is not working like it used to... The formula type "=SUM(A1;B2)" no longer works. It is no longer calculating, it is copying instead... Simple example: consider 4 cells E110, F110, and E111, F111. In F110, I have a number (result from the previous operation). In E111, I have the amount for the next operation. In F111, I would like the result of F110 + or - E111. If I drag the handle at the bottom right of cell F110, it no longer calculates "=SUM(F110;E111)", it simply copies the value of F110 into F111, whereas not long ago, it performed the requested calculation. I don't know what has gone wrong... My file is not very large (8 sheets of about 300 rows each). Version: Excel 2013, which was working fine until now.

Thank you for your responses.

3) Hardware:
"Desktop" computer, "tower", based on x64, running Microsoft Windows 10 Home;
Intel(R) Core(TM) i5 CPU 650 @ 3.20GHz, 3193 MHz, 2 core(s), 4 logical processor(s);
Motherboard: Intel Desktop Board inside DH55TC Media Series;
Physical memory (RAM) installed 4.00 Go.

3 answers

  1.
    JCB40 Posted messages 3060 Registration date   Status Member Last intervention   479
     

    Look in OPTIONS>>>>Formulas>>>>>check if the automatic recalculation box is checked

    1
  2. Quartzite Posted messages 79 Registration date   Status Member Last intervention   1
     

    I looked: the automatic recalculation box was unchecked!

    Hats off JCB40: you solved my problem.

    Once again, I can only admire the efficiency of the "How It Works" forum.

    Thank you! ...

    1
  3. JCB40 Posted messages 3060 Registration date   Status Member Last intervention   479
     

    Hello

    Try to update Excel

    0