View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mark
 
Posts: n/a
Default 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.