extended formulas

[Debby]

i have a worksheet with several sheet tabs. Each worsheet
calculates formulas in every row. In some of the columns
the totals fill in automatically as numbers are entered
for that day. Other columns will not total
automatically. I have to drag the cell above and then
the new number fills in. Why do some fill in
automatically and others do not?

 

[jr]

in TOOLS | OPTIONS | CALCULATION
there is a check for automatic calculation and for
calculation in tables. Perhaps you have the wrong option
checked if the numbers that don't recalculate are part of
a table.

 

[Jim Rech]

This article explains how the Extend List Formats and Formulas feature
works:

http://support.microsoft.com/default.aspx?scid=kb;en-us;231002&Product=xlw