Sum doesn't work automatically

M

Mark

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.
 
N

Niek Otten

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

Bob Phillips

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
M

Mark

Thanks guys. It now works fine.

Bob Phillips said:
Tools>Options>Calculate, and ensure Automatic calculation is set.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
Click to expand...
 
Top