View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob I Bob I is offline
external usenet poster
 
Posts: 2,819
Default sum cells automatically

Clcik Tools, Option, Calculation, Automatic.

Tony Logan wrote:
I've set up some spreadsheets to track server activity. I noticed that on
some of the spreadsheets, each day when I fill in the totals for, say,
columns A through D, then column E automatically populates with the sum. But
on other worksheets this doesn't happen. I'd like to enable this for all my
worksheets, but I don't know how to do it, and have no idea how to explain
the current behavior of "works on some worksheets but not on others".