I created a spreadsheet in Excel 2003 to track fat, carb, and protein
calories from various foods, then add them up. For a while, it would change
the total at the bottom of each column automatically. Then it stopped. Each
column now has to be recalculateds manually (by re-entering the formula)
every time I enter new data. Also, when I copy the formula, the cell window
shows the revised formula, but the total at the bottom is the absolute value
of the cell I was copying from--in other words, suppose the formula for n36
is =sum(n1:n35) and the total is 235. If I copy it to column p, the formula
shown is =sum(p1:p35), but the total is still 235. This is tedious and
frustrating. How can I get back to automatic recalculation?
--BTW, there's no problem in the rows, only the columns.