Sum doesn't work automatically
 

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.

Sum doesn't work automatically
 

OptionsToolsCalculation, check Automatic.
You probably had another workbook open with this setting. The setting
applies to all open workbooks.

--
Kind regards,

Niek Otten

"Mark" wrote in message
...
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.

Sum doesn't work automatically
 

ToolsOptionsCalculate, and ensure Automatic calculation is set.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Mark" wrote in message
...
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.

Sum doesn't work automatically
 

Thanks guys. It now works fine.

"Bob Phillips" wrote:

ToolsOptionsCalculate, and ensure Automatic calculation is set.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Mark" wrote in message
...
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.