Unable to extend a formula

Solved
wawatank Posted messages 35 Status Member -  
wawatank Posted messages 35 Status Member -
Hello,

I’m working with Excel 2010 and Windows 7 64-bit

When I ask Excel for a basic calculation (like =A1*1.015, for a price increase compared to the previous year), and I extend this formula to the following cells, the calculation doesn’t happen. Strangely, the formula title is correct, and just entering the formula bar with F2 and validating without changing anything makes the calculation update.

What is causing this?

Configuration: Windows 7 / Internet Explorer 8.0

2 answers

  1. Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
     
    Hello
    you are probably in manual calculation mode
    File / Excel Options / Formulas and check "Automatic Calculation"
    best regards

    To err is human, to persist is diabolical
    4