Formula Cells do not Automatically update

[Ian Bell]

Hi,

I have been working with Excel 10 for some time, with no real issues. I would class myself as an intermetiate user.

I have used a file many time before and yet today when I used it, the formula cells are not automatically updating. They only change when I save the file, this means that I have to save every time I make any input.

Not sure how the file setting could have changed or of there is a software fault, can anyone help.

Thanks in Advance, Ian

[NeedForExcel]

Under the Formula Tab > Calculation Options > See if it is set to Automatic..

[adhawan06]

Hi Ian Bell,

Welcome to the Forum.

Please take few seconds to marked thread as SOLVED if you have got the answer for your query. Also, please say thanks by adding *Add Reputation to the person who helped you.