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.