Sum doesn't work automatically

[Guest]

I'm using excel to do my bank account where the last three colums are credit,
debit & balance. In the past when I've changed a credit or debit the balance
has been corrected automatically. This now doesn't work until I click on
Save. Are there any settings i need to check? This has only stopped working
today and was fine yesterday.

 

[Niek Otten]

Options>Tools>Calculation, check Automatic.
You probably had another workbook open with this setting. The setting
applies to all open workbooks.

 

[Bob Phillips]

Tools>Options>Calculate, and ensure Automatic calculation is set.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Guest]

Thanks guys. It now works fine.

Tools>Options>Calculate, and ensure Automatic calculation is set.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)